format a date

[Lhuffst]

I have a report that uses the current date. It formats fine but I want the entire month spelled out like:
November 01, 2003

I've tried
long date but that puts in the day of the week which I don't want

I've tried

=Format(Date(),"mmm d yyyy")
But that only spells out Nov

Thanks
Lhuffst

 

[SgtJarrow]

Format(Date(),"mmmm d yyyy")


Note the 4 m's.....

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[Lhuffst]

Thanks