NextBusinessDayCalc: Difference between revisions

From SMTX Wiki
Jump to navigation Jump to search
Created page with "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}', no..."
 
m 1 revision imported
(No difference)

Revision as of 21:44, 25 May 2020

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')))))