Sort by Date on Report

  • Thread starter Thread starter Natasha Bennett
  • Start date Start date
N

Natasha Bennett

Hello,

I have a report in which the records are grouped by date.
When I use the sorting option and sort "ascending", my
date sort like this (for example):
3/1/2004, 3/11/2004, 3/2/2004.....

What must I do to get the dates in the correct order?
 
I have a report in which the records are grouped by date.
When I use the sorting option and sort "ascending", my
date sort like this (for example):
3/1/2004, 3/11/2004, 3/2/2004.....

What must I do to get the dates in the correct order?
Click to expand...

You could go into Regional and Language Options Customize button and change
the Short Date format to MM/dd/yyyy so those dates would appear as
03/01/2004, 03/02/2004, 03/11/2004

Tom Lake
 
Natasha said:
I have a report in which the records are grouped by date.
When I use the sorting option and sort "ascending", my
date sort like this (for example):
3/1/2004, 3/11/2004, 3/2/2004.....
Click to expand...


That's because they are either in a Text field or have
somehow been converted to a text string.

If you can't figure out how to keep the dates as a Date/Time
value, you could bail out on the issue by changing to group
on the expression =CDate(datefield) instead of just using
datefield.
 
Back
Top