Access 2010 Report header with date citeria

[Lissa]

I have created a report and I am using the following for the report header... A "Text Box" with this code for the control source:

="Credit Memo Log " & Format$(DateAdd("m",-1,Now()),"mmmm"", 2015 """). I run the report at monthend. That is why I am using

-1 because it is the next month when I run report. However, I would like to use the date criteria in one of my defined fields cmMonth so that I know I will



always have the correct month on the report header whether I run it current month or next month.

[June7]

Is cmMonth not a full date value - just a month? Is it number (8) or text (August)?