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


Bob Flanagan III
2014-01-27T13:35:49Z
Hello

I an trying to find a Visual Cron formula (vers 6.1.8) that will calculate the Last Work Day before the Last Work Day

i.e. If it is a Tuesday, it will calculate the date for Friday and not Sunday which the formula

{DATEADD(Days|{DATE(LastWorkday|yyyy-MM-dd)}|yyyy-MM-dd|-1|dd/MM/yyyy h:mm tt)}

would do.

On the Monday it would need to return Thursday

Any help would be great

Bob
Sponsor
Forum information
Support
2014-01-28T10:53:47Z
Right now that cannot be easily done with Variables as there are limited calculation possibilities. I think the .NET Task might be better for this. Right now I am moving this to Feature requests as a request to create an offset value - like -1 to last work day Variable.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top