Calculations

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

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