NextBusinessDayCalc

From SMTX Wiki
Revision as of 13:51, 2 October 2024 by Smtxwiki (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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'))