Sort Formatted Date

[Guest]

Hello,
I have a query that formats dates by month and year i.e. in the table data
is 10/6/07 but formatted to Oct 07 with this code Week Ending By Month:
First(Format$([Individual Productivity Table].[Week Ending],'mmm yy')).

I need the query to sort so that Sep 07 comes before Oct 07.

Thanks.

 

[Guest]

The format function returns a string. Therefore these "dates" will be sorted
as text.

Add another column to the query with this in the heading:

SortOrder: [Week Ending]

Sort on this field. You can remove the checkmark in Show if you don't want
to see it.