How can I create a variable to set a last day of last month. I need to change file name from "current file" to "new file name_ 02-28-2011".
Any help is appreciated
last day(#) of month
last day(#) of month
I think you can do this with BASIC.
In order to calculate last date in previous month you should subtract 1 from 1-st date of current month.
Basic expression:
DateSerial(Year(Date), Month(date),1) - 1
Also see this example
This task requires Basic plugin. You can download it here.
In order to calculate last date in previous month you should subtract 1 from 1-st date of current month.
Basic expression:
DateSerial(Year(Date), Month(date),1) - 1
Also see this example
This task requires Basic plugin. You can download it here.
last day(#) of month
That works great!
I needed the month code to always be 2 chars long. (Leading zero if needed) So I added:
Right("0" & cstr(month(Date)-1),2)
I share this in case it helps someone.
Thanks,
Rob
I needed the month code to always be 2 chars long. (Leading zero if needed) So I added:
Right("0" & cstr(month(Date)-1),2)
I share this in case it helps someone.
Thanks,
Rob