By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,649 Members | 2,142 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,649 IT Pros & Developers. It's quick & easy.

Time ascending incorrect !! going nuts !!

P: n/a
I have a to only show date. I set the date to be in ascending order,
but still 01/11/2006 shows first, and 31/10/2006 shows last..It is only
ascending the date and not the complete date including month and
year..please help

Thanks

Nov 3 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Is the field in the table a text field or is it a date/time field.

My guess is that it is a text field. If that is true then, at a
minimum, you will need to create another field in your query that is
defined as:
cdate(fieldname)
And then sort by this field.

Because you are using the European format, you will have to experiment
whether or not even that will work.

If not you may have to break the text field up into date components and
create a date from that to sort by.

Ron
su******@gmail.com wrote:
I have a to only show date. I set the date to be in ascending order,
but still 01/11/2006 shows first, and 31/10/2006 shows last..It is only
ascending the date and not the complete date including month and
year..please help

Thanks
Nov 3 '06 #2

P: n/a
Thanks Ron, works perfectly fine..Don't know what was wrong, it was nt
a text format, but as long as it works, I'm fine..

Nov 6 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.