Time ascending incorrect !! going nuts !!

[sunilkes]

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

[Ron2006]

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

[sunilkes]

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..