I am trying to place a date in the header of my report.

My report is based off of a query that asks for a start and end date. Like for now I put in 4/1/03 and 4/30/03 to print the records between this date range. I want the report header to say April 2003. How can I do this?

I am tring to use =DateAdd("m",-1,Date()), but get 4/14/03 back, how do I get it to say only April 2003

Thanks,
Rob

Format(DateAdd("m",-1,Date()), "mmm" & " " & "yyyy")