Sorting

  • Thread starter Thread starter Josh
  • Start date Start date
J

Josh

I have a date field that I sort in my Query. The date
comes in the format 10/08/2003. When I sort ascending it
only sorts with the day and the month, it pays no
attention to the year. How can I get it to sort correct?

Thank You
 
Is the field you are using in Date/Time format, or perhaps Text format?
Dates should be stored in Date/Time format, which is in fact a
misrepresented (to you) numeric format. As such, it will follow the
sorting rules the way you expect.

Pavel
 
Back
Top