I'm using this code in a textbox in a report to show the current month and year:
I need another field which shows the next month and year (i.e. it would show May 2023 as of today).Code:=Format(Now(),"mmmm yyyy")
I'm not sure how to do this, particularly regarding end of year. I know how to strictly show the next month but I worry in December 2023, it'll show January 2023 because the year needs to change too.
Suggestions?