Sorting Long Dates in query

[JonathanAnon]

I have a list based on a date query. Works fine but when I sort it, it sorts by the numeric value of the day. For example,

12 July 2007
14 July 2007
13 September 2007

is sorted as follows:

12 July 2007
13 September 2007
14 July 2007

The query column is Expr1: Format(datefield, "Long Date")
and sorted ascending.

thanks,
J

 

[KenHigg]

Don't sort it on that field. Create a hidden field using the simple datefield and sort on it.


ken

 

[JonathanAnon]

Yep that's it thanks.

 

[KenHigg]

Cool -