Many people format dates in their queries:
Select fld1, fld2, Format(myDate, "mmmm/yy") as formDate
From ...
Where ...
Order by Format(myDate, "mmmm/yy");
They then don't understand why the records appear in alpha order -
April
August
December
February
January
June
July
March
May
November
October
September
If you simply sort on the original, unformatted date field, the rows are returned in the expected order.
Select fld1, fld2, Format(myDate, "mmmm/yy") as formDate
From ...
Where ...
Order by myDate;
January
February
etc.
The difference is the original date field is actually a number with each succeeding day having a serial number one higher than the previous day. When you format a date, you turn it into a text field and if you sort on a text field, text rules apply. That means that April is the first record you'll see and September is the last because that is how the alphabet works.