Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a button I am using to run a report, when pressed it sets the report to print, before reaching the print section it sets the company and subsidiary. However I also need it to set the month to be the last whole month.
I.e.
I would like to be able to add an action to select "month"
and the field be "last whole month", any ideas of how I can do this? Was thinking of using month(month) -1 but this doesn't work. Any ideas?
Thanks
Ben
Not sure if this is what you intend:
Inputbox > Variable = TheMonth
Button > Action / External / Set variable > Variable = TheMonth ; Value = =month(now())-1
So today this sets TheMonth to 2.
Greetings,
Piet