Date format
 

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

Date format
 

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

Date format
 

that was easy...I feel dumb now

Thanks alot!

NickHK wrote:
Format(Now, "mmmm dd, yyyy")

NickHK

How do I change the date format from 06/07/2007 to June 07, 2007 in a text
string?
[quoted text clipped - 4 lines]

thanks in advance

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