Set a date +14 days

From SMTX Wiki

Revision as of 15:40, 18 June 2019 by Smtxwiki (talk | contribs) (Created page with "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#...")

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

Retrieved from "https://wiki.smt-x.com/index.php?title=Set_a_date_%2B14_days&oldid=218"