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