Last Day of Previous Month

Automise Discussion
1

Whats the best way to get the last day of previous month into an Automise variable?

For example: if today is 04/04/2011, I want the Automise variable to contain value 03/31/2011.
if today is 07/28/2011, the Automise variable should be set to 06/30/2011.

I see that the date function only supports +/- minutes/hours/day/month/year... do I need to use vbscript somehow?

Thanks

2

Hi

You can do this with a very simple VBScript. I have attached an example project that demonstrates this.

Regards,

Steve

DateExample.atz3 (1.996 KB)
3

Very nice!

Thanks for the quick and accurate solution Stephen.