Getting January to show as "January", not "01"

[John Ortt]

I have a Date Field and I am currently using

Month: Format([DateonNote],"mm")

How can I get it to say January instead of "01"

Thanks in advance,

John Ortt

 

[Michel Walsh]

Hi,


Format( Now(), "mmmm" ) or Format(Now(), "mmm")


Hoping it may help,
Vanderghast, Access MVP

 

[John Ortt]

Excellent, Just what I wanted....

Thankyou Michel.