Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Function Index > I

INT

Scroll Prev Top Next More

(INT(arg))

 

Truncates a number that has a REAL, DOUBLE, NUMERIC or CURRENCY data type, returning a value that has an INTEGER data type.

 

The function can also be used to convert numeric TEXT and NOTE variables to the INTEGER data type. In using TEXT/NOTE, the INT function will automatically round and truncate the value.

 

In the following example, the value of vint is 1.

 

SET VAR vint = (INT(1.6))

 

In the following example, the value of vint2 is 7.

 

SET VAR vtext TEXT = '6.8'

SET VAR vint2 = (INT(.vtext))

 

To truncate a text, the following example can be used, where the value of vTruncInt is 1.

 

SET VAR MyTextStringVar TEXT = '1.5'

SET VAR vTruncInt integer = (INT(FLOAT(.MyTextStringVar)))