Question Query Problem

[Steve_T]

Hello i need your help,
I am using a sort string to show only the month of a date "Month: Month([ArrivalDate])"
It returns a number as a month eg April reads as 4. I need it to return the month as it is shown on the table.
The format of the Date is dd-mmmm-yy.

Any help would be great

 

[pbaldy]

Try

Format([ArrivalDate], "mmmm")

 

[Steve_T]

Thanks a lot, that works fine. I am in your debt