By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,247 Members | 1,287 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,247 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

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.