Set a date +14 days

From SMTX Wiki
Revision as of 21:44, 25 May 2020 by Smtxwiki (talk | contribs) (1 revision imported)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Show a date, in format dd/MM/yyyy, that is 14 days after the start date of the ticket

   FORMAT('{0:dd/MM/yyyy}', DATEADD(TODATE('#REPLACE-STEP-PROCESS-DateStarted-yyyyMMdd#', 'yyyyMMdd'),14,'D'))