NextBusinessDayCalc

From SMTX Wiki
Jump to navigation Jump to search

To calculate the next business in a form use this calculation:

format('{0:yyyyMMdd}', todate(IIF(format('{0:ddd}', now())='Fr',dateadd(now(),3,'d'), IIF(format('{0:ddd}', now())='Sa',dateadd(now(),2,'d'), dateadd(now(),1,'d')))))