Format Date with Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Lamar said:
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?
Click to expand...


The format spec needs to be in quotes:

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