Hard-coding a 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.
 
D

Daryl S

Erin -

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report problem 3
Count the number of times the date is a Monday, Tuesday, etc 5
Date Heading 6
Date (multiple) format in textbox 1
Difference between 2 dates 7
How do I format a date to print in all capital letters? 3
UCase with Now() function 1
Format Date with Text 1

Top