Sorting by month

  • Thread starter Thread starter Karlos
  • Start date Start date
K

Karlos

hi,

is there any way i can sort my date field by month.

the date is set out in this way dd/mm/yyyy

so is it possible to sort it by month?

cheers in advance
 
Hi,
If you only want to sort by month, use this Order By:

Order By Month(yourDateField)
 
Hi,
In the query grid, create a calculated field.

myMonth:Month(yourDateField)

Sort on that field. You don't have to display this field if you don't want to.

If you go into SQL view, this translates into:
Order By Month(yourDateField)

Substitue the real field name for yourDateField
 
Back
Top