Converting 1/1/2005 date into sortable format

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Hi All,
When I sort in ascending order by a field in Access standard date/time
format, I get messed up results. 8/10/2005 is sorted before 8/9/2005.
Is there a way that I can convert date format to a format that would be
sortable?
Thanks,
Phil
 
Update!
I was using an extensive advanced filter in a form when I was getting
wrong results. Rebuilding the filter seems to have fixed the problem
and Access built in sort for dates seems to work fine now.
Thanks,
Phil
 
Back
Top