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

Another way is to use bd in DateAdd

FORMAT('{0:yyyyMMdd}',DateAdd(todate('#REPLACE-FORMFIELD-FormName||dfDatumVanaf||#'), #REPLACE-FORMFIELD-FormName||liSoortVerlof||AantalDagen#,'bd'))