W
waterman
The values in the table I'm working with are in a general
date format (mm/dd/yyyy hh:mm:ss am/pm). I have a need to
group these dates together and drop the time portion of
the date. I accomplish this by the following:
DateSort: Format$([Date], "mm/dd/yyyy")
This is all well and good until it's time for me to sort
the values. Instead of getting them in chronological
order, I seem to get them in alphabetical order, as seen
in the following:
01/01/2002
01/01/2003
01/02/2002
01/02/2003
I need the data to sort in chronological order. Is there
a way to accomplish this?
date format (mm/dd/yyyy hh:mm:ss am/pm). I have a need to
group these dates together and drop the time portion of
the date. I accomplish this by the following:
DateSort: Format$([Date], "mm/dd/yyyy")
This is all well and good until it's time for me to sort
the values. Instead of getting them in chronological
order, I seem to get them in alphabetical order, as seen
in the following:
01/01/2002
01/01/2003
01/02/2002
01/02/2003
I need the data to sort in chronological order. Is there
a way to accomplish this?