Date 2

Duane8889 · Jun 12, 2005

Hello
How can I display current date in a textbox? ex June 12, 2005. I don't want 6/12/05 or Sunday, June 12, 2005.
I tried

Code:

=Format(Date(),"mmmm dd "," yyyy")

in the control source of the textbox on a form but I just get #Error in the textbox.

Remou · Jun 12, 2005

Hi

Code:

=Format(Date(),"mmmm dd"", ""yyyy")

Duane8889 · Jun 12, 2005

thanks Remou, just what I needed!

earthandfire · Jun 12, 2005

Why all the extra quote symbols:

=Format(Date(), "mmmm dd, yyyy")

should do the trick.

Hope this helps.

Duane8889 · Jun 12, 2005

earthandfire
Yes, you are right it does work as you showed!
thankQ