A abledog Registered User. Local time Today, 10:47 Joined Nov 11, 2008 Messages 15 Nov 24, 2008 #1 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....
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....
Brianwarnock Retired Local time Today, 18:47 Joined Jun 2, 2003 Messages 12,667 Nov 24, 2008 #2 Format(DateAdd("m",1,Date()),"mmmm") Use Date rather than Now as you don't need time
A abledog Registered User. Local time Today, 10:47 Joined Nov 11, 2008 Messages 15 Nov 24, 2008 #3 Thanks a lot....I appreciate it....