format date to month in report

[legendv]

I'm a average user...
In a report an inputed date is grouped on the month and associated records appropriately fall in their place, however I don't want the 03/14/02 displayed. I would prefer the month format, i.e...
if date is 03/14/02 display would be March
if date is 02/??/02 display would be Februrary
if date is 01/??/?? display would be January
if date is 04/??/?? display would be April

I think you get the picture. Is there a way to format the date to month on the report?

Thanks in advance,
Jon

 

[Lyn Mac]

To get the name of the month of a given date
use the Month() and MonthName() functions.
Month() gives the month no. 1,2,3...
MonthName() gives the whole name of the month.

Try:

=MonthName(Month([DateFiedl]))

HTH,

Lyn

 

[legendv]

Thanks Lyn

 

[legendv]

=MonthName(Month([DateField]))

this asked me to input the MonthName when the query ran? Is it supposed to? I want the report to recognize what the date is and display the correct month.

 

[Pat Hartman]

MonthName() is not a valid function in A97. I don't know about other versions. Use the Format() function:

=Format(YourDate,"mmmm")

 

[legendv]

Thanks Pat, that worked!!!!!

 

[Lyn Mac]

That explains.

I was using Access2K and AccessXP.

Thanks any way.

Lyn

 

[Irishladd46]

How would I display a date in a report as June 1, 2016?

 

[arnelgp]

=Format(Date(), "mmmm d, yyyy")