Format Date()

  • Thread starter Thread starter DD
  • Start date Start date
D

DD

I want to create a report that has the current date in it.
So the text box contains =Date() but then I need to add
the date format to this so the date comes out as for
instance February 8, 2004 regardless of the regional
settings. I cannot figure out the correct syntax for this.
Thanks!
 
DD said:
I want to create a report that has the current date in it.
So the text box contains =Date() but then I need to add
the date format to this so the date comes out as for
instance February 8, 2004 regardless of the regional
settings. I cannot figure out the correct syntax for this.
Click to expand...


Two ways, you can use the Format function in the text box's
Control source:
=Format(Date(), "mmmm d\, yyyy")

but in your case it's a little cleaner for the text box
expression to be just:
=Date()
and set its Format property to:
mmmm d\, yyyy
 
Back
Top