Need to sort a Date field

[sabavno]

Hi,

I have this Date field in the following format:
Expr1: Format([DateCreated],'mmmm", "yyyy')

When I try to sort it, say, descending, I get the following:

September, 2002
October, 2002

So, as I understand it sorts it as a string, rather then as a date

What should I do to get:

October, 2002
September, 2002
Etc.

Thanks.

 

[KenReay]

Hi

A few possibilities here, but for one:

Make yourself another calculated field in your query so:

Expr2: Format(Year([DateCreated]),"0000&quot & Format(Month([DateCreated]),"00&quot

and sort on that

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[jimmythegeek]

You should be able to add the DateCreated field to the query, sort on that, and don't show it. Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?