Format Date with Text

[Guest]

I am trying to put the date with text in a text box on a report but can not
figure out the syntax:
="Dated on " & Format(Date(), mmmm dd","yyyy) & "."

So I want this to show on the report: "Dated on September 7, 2006." I need
to format the date. Can all this be done in single text box?

Thanks for any help.

 

[Marshall Barton]

I am trying to put the date with text in a text box on a report but can not
figure out the syntax:
="Dated on " & Format(Date(), mmmm dd","yyyy) & "."

So I want this to show on the report: "Dated on September 7, 2006." I need
to format the date. Can all this be done in single text box?

The format spec needs to be in quotes:

="Dated on " & Format(Date(), "mmmm dd\, yyyy") & "."