I created a report with input date parameters. Works well.

In the header, I have a text box and in the control source, as =date().

When the report is ran, it shows the current date. Its in the footer too.

What I want to show is the header is the month for the date the report was ran.

So if someone wanted to run the report for Dec 1 thru Dec 31 of this year. I want the header to show "December 2007"

Also, if someone needs to run it for prior months, like April 2007. I want it to read "April 2007"

Any assistance would be nice!

Matt