Hard-coding a date

  • Thread starter Thread starter ErinCullen
  • Start date Start date
E

ErinCullen

I'm trying to hard-code a date onto a report. I know I have to use a text box
and then use the builder for the control source. I also know I have to use
the format and date functions, but I can't figure out the correct formatting
for the expression.

This is what I have been typing in: format date() "MMMM D, YYYY" but it
never works.
 
Erin -

To format today's date, use this as the control source of your field:

=format(date(), "MMMM D, YYYY")
 
Back
Top