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

J

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
 
M

Michel Walsh

Hi,


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


Hoping it may help,
Vanderghast, Access MVP
 
Top