Convert a value of one data type into a value of another data type using conversion functions. The following conversion functions are available:

• from string to integer, number, currency, percentage, date, dateTime or boolean
• from integer to string, number, currency or percentage
• from number to string, integer, currency or percentage
• from currency to string, integer or number
• from percentage to string, integer or number
• from date to string or dateTime
• from dateTime to string or date
• from boolean to string, integer or number

Syntax

TEXT(integer, [format], [locale])
TEXT(number, [format], [locale])
TEXT(currency, [format], [locale])
TEXT(percentage, [format], [locale])
TEXT(date, [format])
TEXT(dateTime, [format])
TEXT(boolean, [format])

INTEGER(string, [format], [locale])
INTEGER(number)
INTEGER(currency)
INTEGER(percentage)
INTEGER(boolean)

NUMBER(string, [format], [locale])
NUMBER(integer)
NUMBER(currency)
NUMBER(percentage)
NUMBER(boolean)

CURRENCY(string, [format], [locale]
CURRENCY(integer)
CURRENCY(number)

PERCENTAGE(string, [format], [locale]
PERCENTAGE(integer)
PERCENTAGE(number)

DATE(string, [format])
DATE(dateTime)

DATETIME(string, [format])
DATETIME(date)

BOOLEAN(string, [format])

• value - The value of the date type that is converted.
• format - The format used for conversion. Format must be enclosed by quotes, e.g. “00.00”.
• locale - Locale specifies a combination of language and country. A locale in the option set will override the one that is used as default in the project. Commonly used are en-US, en-GB, nl-NL, nl-BE, fr-FR. The list of language codes can be found here. A list of country codes can be found here.

Examples

• TEXT(PERCENTAGE(1.2), “00.00”, “nl-NL”) results in a string value “01,20”
• INTEGER(“1,0”, ”#0.0”, “nl-NL”) results in an integer value 1
• NUMBER(TRUE) results in a number value 1.0000
• CURRENCY(“1.2”, “invalidPattern”) results in a currency value 1.20 (an unknown pattern will be ignored)
• DATETIME(“19861221 12:02:56”, “yyyyMMdd HH:mm:ss”) results in a dateTime value 1986-12-21T12:02:56
• BOOLEAN(“1”,”1;0”) results in a boolean value TRUE

Formats in the runtime

Each data type is defined in the runtime as follows:

• INTEGER #0
• NUMBER #0.0000
• CURRENCY #0.00
• PERCENTAGE #0.00
• BOOLEAN true,1;false,0

E.g.: numbers will always be shown with 4 decimals.