Date format

[blackbox via OfficeKB.com]

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

 

[NickHK]

Format(Now, "mmmm dd, yyyy")

NickHK

 

[blackbox via OfficeKB.com]

that was easy...I feel dumb now

Thanks alot!

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