Text Box - Display next month?

abledog

Registered User.
Local time
Today, 10:47
Joined
Nov 11, 2008
Messages
15
Hello, I am using =Format(Now(),"mmmm") to print the current month (which spits out November) and I need a similar query to print the next month (should spit out December). Would anybody know how to do this...

Thanks....
 
Format(DateAdd("m",1,Date()),"mmmm")

Use Date rather than Now as you don't need time
 
Thanks a lot....I appreciate it....
 

Users who are viewing this thread

Back
Top Bottom