Month Format

[pgh2377]

Hello,

I'm trying to make a month format by month name, i.e. January, february, etc.. I formatted the date with the Month fuction which made July-7, August=8, etc... However, the access manual says use MonthName function to get the month name, but when I do it I get "Undefined Expression" Does anyone have any suggestions?

 

[SkipVought]

hi,

[tt]
Format(MyDate, "mmmm")
[/tt]

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[hymn]

Have a look in Access help under
Format Property - Date/Time Data Type

Hope this helps
Hymn

 

[cheerio]

Monthname is a VBA function which I think was introduced in Office 2k.

It expects a number from 1 to 12 and returns the month name.

The big difference with the Format function mentioned above is that Monthname returns a localised name.

So while I see April in response to Monthname(4) a frenchman sees Avril.