ASP Date Sort
I need to sort the records in a WADA_Recordset by the Date Field.
Sorts fine in Access, field is setup as a date field.
When I use ORDER BY ExpiryDate, I get:
12/1/2010
4/15/2010
It is sorting on the 1 in 12 (December) rather than the Month in proper order. Expanded, I'm going to get:
October
November
December
April
August
February .....
I've tried from the recordset and I've tried adding a Server Sort Behaviour but I get the same result. 2 hours of Googling has netted me zero.
Does anyone have a solution? I suspect I need something like dateformat() in the Query but I have no idea what the syntax would be.