date ordering issue

[llaman]

I have queries reformating a date column with

"MonthYear: Format([entrydate],"mm") & Format([entrdate]. "yyyy")
ordered by ascending

The problem is that when I run the query, it orders the dates as
1/2003
1/2004
2/2003
2/2003
3/2003
3/2004
...

Do you know how to fix this?

Thanks in advance

 

[Andrew Fergus]

Hi,

I can't seem to do this using formatting techniques and I'm not good with VB but I did get it to work by creating another column in your query, like this :

MonthYear2: Format([entrydate],"yyyy") & "/" & Format([entrydate],"mm")

then remove the sorting from your first column, sort by this new column and then untick the "Show" box on this new column.

HTH, Andrew.

 

[llaman]

I think that solution will get us by tomorrow, but does anyone know of possibly a better more permanent solution that will not require different formatting or an extra column?