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