https://wiki.smt-x.com/index.php?action=history&feed=atom&title=Calculations Calculations - Revision history 2026-04-04T00:39:49Z Revision history for this page on the wiki MediaWiki 1.44.3 https://wiki.smt-x.com/index.php?title=Calculations&diff=33&oldid=prev Smtxwiki: 1 revision imported 2020-05-25T20:44:27Z <p>1 revision imported</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <tr class="diff-title" lang="en"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 22:44, 25 May 2020</td> </tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div> </td></tr></table> Smtxwiki https://wiki.smt-x.com/index.php?title=Calculations&diff=32&oldid=prev Smtxwiki at 07:30, 10 January 2019 2019-01-10T07:30:44Z <p></p> <p><b>New page</b></p><div>You can use this also to:<br /> <br /> - &#039;&#039;&#039;round numbers&#039;&#039;&#039;: This will convert anything above 1,5 to 2 and below 1,5 to 1&lt;br&gt;<br /> FORMAT(&#039;{0:0}&#039;, TONUMBER(&#039;#REPLACE-FORMFIELD-Numbers example||Amount09||#&#039;))<br /> &lt;br&gt;&lt;br&gt;<br /> - &#039;&#039;&#039;calculate the difference between 2 dates&#039;&#039;&#039;: &lt;br&gt;<br /> DATEDIFF(todate(&#039;#REPLACE-FORMFIELD-DateChecks||Date1||#&#039;),todate(&#039;#REPLACE-FORMFIELD-DateChecks||Date2||#&#039;), &#039;D&#039;)</div> Smtxwiki