G
Guest
My query sums all shipments by month. So the date field is formated as:
ShipDate By Month: Format$([ShipDate],'mmmm yyyy')
I need to sort so the dates are in order, but it's seeing them as text and
sorting November, October, September instead of September, October, November.
How can I format this so it will sort correctly?
ShipDate By Month: Format$([ShipDate],'mmmm yyyy')
I need to sort so the dates are in order, but it's seeing them as text and
sorting November, October, September instead of September, October, November.
How can I format this so it will sort correctly?