Sort Date

[RaptureReady]

Hey all, I looked throught a couple of threads for sorting, but could not find exactly what I need.

Basically, I have a list of dates:

10-Aug-07
20-Oct-07
13-Nov-07
etc...

and when I try and sort these dates from earliest to latest, it only reads the number and not the month, like:

10-Aug-07
13-Nov-07
20-Oct-07
etc...

How would I make it sort by date and month?

Thanks,
RR

 

[boblarson]

and when I try and sort these dates from earliest to latest, it only reads the number and not the month, like:

10-Aug-07
13-Nov-07
20-Oct-07

By the way, that IS sorted by date AND month if you look. The months are in alphabetical order.

So, you need a separate sort field with:

MySortField:Format([YourDateField],"yyyy/mm/dd")

and set it to sort Ascending.

 

[CraigDolphin]

The problem looks like you have the data incorrectly stored as text datatype, not as a date datatype.

Try making a query of your table but instead of directly adding [YourTextDateField] to the grid, add a field where the field is:
MyConvertedDate: CDate([YourTextDateField])

And sort ascending

 

[RaptureReady]

Hey thanks all, but that was it CraigDolphin, I had the field set to text and not date...duh...lol

Appreciate the help.

RR

 

[CraigDolphin]

Glad to help