Sort by Month

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I have the following expression in a column of a query.
FinalShipMonth: (Format([FinalPlantShipDate],"mmm")).

The months are sorting alphabetically, even when I click
Ascending. I'm assuming because my expression isn't
reading date field any longer.

Is there a way I can rewrite this formula so I can sort by
month; jan, feb, mar, etc...

Thanks for your help,
Alex
 
Alex,

To sort by the numeric value of the month, add a column to your query:

FinalShipMonth_Sort: Month([FinalPlantShipDate])

and, sort on that column.

hth,
 
Back
Top