Setting date to last whole month using actions

[#1]

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

[#2]

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