Now Function Custom Format

[DrJohn]

I would like to use the =Now() function but have it display the results as for example Wednesday, March 15, 2016 followed by a name



Any suggestions.

John

[pbaldy]

this help?

?format(date,"dddd, mmmm d yyyy")
Tuesday, March 15 2016

[DrJohn]

Are you suggesting:

=Now(date,"dddd, mmmm d yyyy")

That doesn't seem to work. The date needs to be dynamic - current date.

Thanks John

[JoeM]

Where exactly are you displaying this (TextBox in a Form, TextBox in a Report, Calculated Field in a Query, etc)?
You would just use the NOW() function, and apply a Custom Format to its display.

[DrJohn]

It is in the Page Footer of a Report. When I created the Report it automatically put =Now() in the footer and properly displays the current date.
I want to change the format of that date. I gues my question is how do you apply a custom format to Now()

[JoeM]

OK. So just switch the Report to Design View, select the Text Box that the date is appearing in, open up the Properties and change the Format value to the format you want to see (dddd, mmmm d yyyy or whatever format variation you want).

[pbaldy]

Are you suggesting:

=Now(date,"dddd, mmmm d yyyy")

That doesn't seem to work. The date needs to be dynamic - current date.

Thanks John

No, I'm suggesting what I posted. The Now() function includes the time, the Date() function just the date.

[DrJohn]

Thank you. I had tried something similar but had some syntax errors.

[pbaldy]

No problem, and welcome to the site by the way.

[DrJohn]

To sum up, here's what worked:
=Now()
Properties Sheet/Format for the field
dddd", "mmmm dd", "yyyy" FI. LastName"
Produced
Wednesday, March 16, 2016 FI. LastName

Thanks again.