Set a date +14 days: Difference between revisions

From SMTX Wiki
Jump to navigation Jump to search
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#..."
 
m 1 revision imported
 
(No difference)

Latest revision as of 21:44, 25 May 2020

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