---
title: "TOINTEGER"
description: "TOINTEGER"
keywords: "TOINTEGER"
url: "https://myrapidi.com/wiki/tointeger"
locale: "en"
published: "2009-05-15T10:01:26Z"
modified: "2012-11-08T07:49:26Z"
---

# 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.

 

**Example 1:**

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

**Example 2:**

> ##TOINTEGER(Number) / 100