Why do I get different results?

[ajdinbphys]

Why doesn't ALL work for the date column when it's in the date format? The only thing that changes in the photos below is the format of the date table.

[johnt75]

Do you have auto date/time turned on, so that when the column is a date it shows a date hierarchy automatically? If so, you could either turn that option off or just use ALL('Sales Table') instead of listing each column individually.