Date formatting within concatenated text box

[gheyman]

I want to put the date on my form. But I want it to say "Today is: .........."

I know how to concatenate it ("Today is: " & NOW()) but how do I get the date formatted properly? What I am doing is giving me 7/1/2017 4:41:35 PM

I want it to show Today is: Saturday, July 01, 2017 (the day, month day and year)

 

[Trevor_S]

If its in a formula, try:
"Today is: " & TEXT(NOW(),"dddd, mmmm dd, yyyy")
If its in a macro, try:

"Today is: " & Format(Now, "dddd, mmmm dd, yyyy")

 

[gheyman]

"Today is: " & TEXT(NOW(),"dddd, mmmm dd, yyyy") resulted in #Name?

 

[gheyman]

PS Not in VBA its an unbound text box on an access form.

 

[Trevor_S]

Sorry, I picked this up in the "zero replies" search, without noticing that it was an Access rather than Excel question.
I've not used Access much in the past, and don't still have a copy if the software (so can't test it), but have found the following using Google - does it solve your question? The format its demonstrating is different to the one that you want, but presumably you can just change the order of the elements: https://www.techonthenet.com/access/forms/format_date2007.php

 

[gheyman]

Sorry, I picked this up in the "zero replies" search, without noticing that it was an Access rather than Excel question.
I've not used Access much in the past, and don't still have a copy if the software (so can't test it), but have found the following using Google - does it solve your question? The format its demonstrating is different to the one that you want, but presumably you can just change the order of the elements: https://www.techonthenet.com/access/forms/format_date2007.php

Thanks but that doesn't help with formatting within the concatenation problem. I thought you were assuming this was excel because I'm pretty goo in excel and recognized the suggestion as what you would use for excel. Thanks for trying.

 

[welshgasman]

"Today is: " & Format(Now, "dddd, mmmm dd, yyyy")

works fine in vba
if using as a control source, prefix it with =

 

[gheyman]

That worked. Thank you.