Calculations

From SMTX Wiki
Jump to navigation Jump to search

You can use this also to:

- round numbers: This will convert anything above 1,5 to 2 and below 1,5 to 1

   FORMAT('{0:0}', TONUMBER('#REPLACE-FORMFIELD-Numbers example||Amount09||#'))



- calculate the difference between 2 dates:

   DATEDIFF(todate('#REPLACE-FORMFIELD-DateChecks||Date1||#'),todate('#REPLACE-FORMFIELD-DateChecks||Date2||#'), 'D')