NOW() on reports

[unclefink]

I was wondering if anyone might be able to help me with something. I have created a report with a date on the top using a "label" coded with =now() which reports back with a format of "Wednesday July 25, 2012", is there additional code or another code I could use to have my result come back with just the date without the day of week.

 

[John Big Booty]

I'd use the Date() function in preference to the Now() function.

You can use the Format(with Dates) function to format the date on your report.

 

[unclefink]

Is it possible to use Date() in July 25, 2012 format rather than 7/25/12 format?

 

[John Big Booty]

Sure is have a look at the Format(with Dates) function I linked to in my previous post.

 

[unclefink]

Thank you for the help, one more question. I am not at all familiar with vba, where do I put this syntax. It looks like this would be the proper format for my need. (#17/04/2004#, "Long Date")

 

[John Big Booty]

You could put it as the Control Source of an unbound field;

=Format (Date(), "Long Date"))

if you want a dynamic date, or the format you have suggested for a static date.

 

[unclefink]

It appears as though either way works; however, I want the date to show only as July 26, 2012 rather than Thursday, July 26, 2012. I do not want the day of week shown.

 

[unclefink]

Thank you very much everyone for your help. This worked perfectly and exactly what I was trying to do.