Date/Time Question

[dsomers]

Hello all! This may sound like a silly question, but its about to drive me up the wall. I'm working on a report and at the top I need it to say:

For the Month of <Month> <Year> (ie. For the Month of November 2003)

I've done the insert date/time and it just shows the current date. I need it to just show the month and year and automatically update as the months progress. Can somebody help me?

Thanks!
David Somers

 

[namliam]

You prob have something like =Date()

Try changing that to ="The month of " & Format(date(), "mmmm yyyy")

Regards