Dates In A Report

[scubagal]

I have a report that looks great except that the dates are not in order. It appears that the entries for each person are listed with the times in descending order instead of the date. Example:



John Doe 1-13-12 1:41am
1-6-12 9:15am

I need it to list by date not time. Will someone point me in the right direction? Thanks.

[pbaldy]

First make sure the field(s) are specified correctly in Sorting and Grouping. Next, make sure the field is of date/time data type not text. What you posted could be an alphabetic sort as well (1 comes before 6).

[boblarson]

You need to set a Sort Order on the date field in the Report's SORTING AND GROUPING.

[boblarson]

I'm Too slow on the draw today.

[scubagal]

Thanks. I'll give it a go.