TOINTEGER(data);

This function can be used if you want to transfer data from a text field (date etc.) to an Integer.  It converts the value to INTEGER which ensures a correct comparison on lookup when e.g. transferring a field to a INTEGER field or if you need to calculate on the value.

Example1

##TOINTEGER(Points) > 15000,'Active','Inactive')

 

Example2

##TOINTEGER(Number) / 100