NextBusinessDayCalc

From SMTX Wiki
Revision as of 11:12, 19 December 2016 by Smtxwiki (talk | contribs) (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...")
(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')))))
Retrieved from "https://wiki.smt-x.com/index.php?title=NextBusinessDayCalc&oldid=164"