Formatting date in header

[jomili]

I've got a macro that creates a report, and the last piece is to createt the header. I have a standard header I've been told to use, and it contains the date. How would I automate the header to include the date in the format I need? Here's how the header is supposed to be:

Regional Filled to Hiring Target Comparison (Filled current as of January 27, 2011)

I'd want the "January 27, 2011" replaced with the current date each time I run my macro to create the report. I'm not posting my macro as none of it relates to this header, so I didn't think it would help.

Thanks in advance for what I know are going to be good solid tips.

Thanks,
John