Sorting Dates in Text Fields

  • Thread starter Thread starter JWeaver
  • Start date Start date
J

JWeaver

I need to sort dates that are stored in Text fields. Right now, dates like
01/01/09 are sorted ahead of 12/01/08. How can I fix this without changing
the field type?
 
You could create a query with a calculated field using the CDate function;

SELECT CDate([YourDateField]) AS SortedDate FROM tblYourTable
ORDER BY SortedDate;

Curious why you don't just make the field a Date/Time data type??
 
Back
Top