423,818 Members | 2,250 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,818 IT Pros & Developers. It's quick & easy.

date sort in form

P: 3
I created a database and wanted to view my multi-year data in date order. Unfortunately, it sorts the info in the right month and day but doesn't by year. For example, 1/17/2006, 1/18/2006, 1/20/2007, 2/2/2006, etc. Any tips on how to fix this? Thanks!
Jul 26 '06 #1
Share this Question
Share on Google+
2 Replies


Banfa
Expert Mod 5K+
P: 8,916
The problem is the order of the fields that you are using to sort on. When sorting dates the best method is to format them as YYYY/MM/DD before sorting, this way it will get the dates in chronological order.

Also note I have used DD i.e. 2 digit day and MM 2 digit month if you do not do this then the 20th will come before 3rd and November and December (11 and 12) will come just after January and before all the other months of the year.
Jul 28 '06 #2

P: 3
It's perfect. I got it to work. Thanks so much for your help! :)
Jul 28 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.