Dates not sorting correctly 1

[kentwoodjean]

Probably an easy question, but here goes. I have used search to check articles, but can't find.

Have a report built off a query that contains a date field w/format of mm:dd:yyyy. The query sort field is set at Acesending and the date order is perfect. The report is grouped by week, and the sorting/grouping is set to acesending order. Yet, the dates within each week are not all correct. I.e. they may be in an order like: 3/12, 3/8/,3/9,3/10,3/11 or 5/20,5/21,5/17,518,5/19. Each date has the year 2004 following.

Why does this happen and how can I correct?

 

[lupins46]

The output of format is a string. So the 'date' values are sorted according to string sort rules.
Format the dates in your report instead.

 

[kentwoodjean]

Thanks for the tip. I knew it was probably simple, but was just having trouble getting there.