Wanted to add that the incorrect sorting is when I use the date in an index of a table. Do I have to year() + month() + day() for the index?

Brenda