Formatting auto date in MS Access Reports

[RabbieBurns]

Probably very simple but I cant figure it out. Trying to get the date showing as just

 

FullMonthName Year

 

so it would just show eg June 2008.

 

Cant seem to stop it from showing the day as well just now.

 

Any suggestions please?

[srochford]

Make the format string mmmm yyyy

 

(mm would give 01, 02 ... 12; mmm gives Jan, Feb etc)

[RabbieBurns]

Where do I change the format string?

 

I just have

=date()

just now, and putting

=date(mmmm yyyy)

doesnt work?

[markj_metcalfe]

You will enter it as =Format(Now(), "mmmm yyyy")

 

You can use either Date() or Now()

Edited June 24, 2008 by markj_metcalfe

[RabbieBurns]

Ah nice one. Cheers!!