Displaying The Long Form of a Month Extracted from a Date 1

[xweyer]

I have a report based on a query with a parameter [Date1]. What I want to accomplish is to have the month displayed (ie "June&quot at the top of the report.

I can separate the numeric value of the month using DatePart("m",[Date1]) but I can't figure out how to use a function to get "June" to display instead of "6".

I can get “June” to display by linking to a table I’ve created associating the month name with its number but I would think there is a more direct way of doing this using a function.

(The help information on MSAccess functions is pretty pathetic.)

 

[mpastore]

Use format:

?format(date(),"mmmm&quot

yields: June

Mike Pastore

Hats off to (Roy) Harper

 

[xweyer]

Thanks.

I followed your example and substituted my parameter (Format([Date1],"mmmm&quot and it worked perfectly.