NextBusinessDayCalc - Revision history

Smtxwiki at 12:51, 2 October 2024

2024-10-02T12:51:39Z

← Older revision		Revision as of 14:51, 2 October 2024
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'))

Smtxwiki: 1 revision imported

2020-05-25T20:44:29Z

1 revision imported

← Older revision	Revision as of 22:44, 25 May 2020
(No difference)

Smtxwiki: 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..."

2016-12-19T10:12:26Z

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..."

New page

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