Format(Now, "mmmm dd, yyyy")

NickHK

"blackbox via OfficeKB.com" <u20390@uwe wrote in message
news:73558009e62de@uwe...
How do I change the date format from 06/07/2007 to June 07, 2007 in a text
string?

this is what I'm using now

"Evening Shift/Night Shift Checklist for " & Format(Now, "mm-dd-yyyy")

thanks in advance

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1