Calculations: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
m 1 revision imported |
(No difference)
|
Latest revision as of 21:44, 25 May 2020
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')