Display following month on a form in label or text box

stevekos07

Registered User.
Local time
Today, 04:58
Joined
Jul 26, 2015
Messages
174
I want a form to display the following month and year in either a label or text box. The form is based on a query that filters a date range to the following month's dates so I want to display the month and year in the header. I just need the correct function for this.
 
something like

format(dateadd("m",1,Date()),"mmm yyyy")
 
something like

format(dateadd("m",1,Date()),"mmm yyyy")

Works perfectly! I had the elements but the formatting got me (again!)

Cheers!
Steve.
 

Users who are viewing this thread

Back
Top Bottom