Calculations

From SMTX Wiki
Revision as of 08:30, 10 January 2019 by Smtxwiki (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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')