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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
Remove date format? 3
Problem formatting dates from CSV file 2
Summary Query - grouping by Month 1
Mixed dates 5
How to Export Gmail Emails to PST Format? 4
text date to date format 5
Date Range Prompt 5

Back
Top