Translating a number date to a text month? 1

[jbelf]

Hi,

I have a date field, but I'd like to display the text 'month' for some graphing and reports. I've converted the date (6/2/03) to the number month (6)using DatePart("m",[end date]), however this only converts it to a numbered month (6). How can I get this to display 'June'?

Any insights greatly appreciated.

 

[GoDawgs]

format([end date],"mmmm&quot. That's all you need. Hope that helps.

Kevin

 

[mikevh]

This may not be the only way, but you could pass the DatePart expression to MonthName:

monthname(DatePart("m",[end date]))