Sorting Dates in Acsending Order

[Random_Guy]

On my query, I wish to sort my dates in ascending order of months, not year. At the moment, my date format is dd/mm/yyyy, and I wish to keep it this way.

Whenever I sort the date in ascending order, this is what happens:

01/05/1994
24/08/1994
02/02/1995
15/03/2000

As you can see, I want to sort the dates in month order, which means that this is the order which I want:
02/02/1995
15/03/2000
01/05/1994
24/08/1994

Can this be done?

Thanks.

 

[namliam]

make a new column with the function: Format([yourDateField], "MMDDYYYY")
Sort on this new column, you can even hide the column from view...

alternatively... if you want to sort on year next instead of day...
Format([yourDateField], "MMYYYYDD")

Or use the Year, Month, Day functions in a simular hidden column to sort..

Good luck.... and welcome to AWF

 

[Random_Guy]

Thanks a bunch! Now I'll pass my IT!