Month Name

[Costefran]

Can anyone help with SQL to find the month name of a field in my query called "Date"

I can find the number of the month with

Month({Date])

But thought I would be able to use the following to find the month name

MonthName([Date])

I get the message saying its too complex to be evaluated

Thanks

 

[SkipVought]

Hi,

Date is a reserve word. NOt a smart idea to use reserve works as field names...

Format([Date],"mmmm")

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Costefran]

Many thanks