NextBusinessDayCalc: Difference between revisions
Jump to navigation
Jump to search
m 1 revision imported |
No edit summary |
||
| Line 2: | Line 2: | ||
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'))))) | 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')) | |||
Latest revision as of 13:51, 2 October 2024
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'))