Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


vamllp-itadmin
2017-11-30T17:36:16Z
Hi
Does anyone know of a simple way to return the last day (not work day) of the previous month in the date variables?
Thanks
Sponsor
Forum information
Gary_W
2017-11-30T18:20:50Z
Get today's date using DATEFORMAT, but specify the the day as the first and have the function give the current month/year. Then subtract 1 day from that using a negative value in DATEADD.

{DATEADD(Days|{DATEFORMAT(01/M/yyyy)}|d/M/yyyy|-1|d/M/yyyy)}
vamllp-itadmin
2017-12-01T09:56:56Z
Originally Posted by: Gary_W 

Get today's date using DATEFORMAT, but specify the the day as the first and have the function give the current month/year. Then subtract 1 day from that using a negative value in DATEADD.

{DATEADD(Days|{DATEFORMAT(01/M/yyyy)}|d/M/yyyy|-1|d/M/yyyy)}



@gary_w thanks, exactly what I was looking for!
Scroll to Top