Page History

Learn more about the conversion functions TEXT, INTEGER, NUMBER, CURRENCY, PERCENTAGE, DATE, DATETIME, BOOLEAN. 

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

...

Overview

...

On this page

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.

Default formats

For all conversion functions that use a string as parameter (e.g., DATETIME(string, [format])), the [format] describes the format in which the string parameter is in. By default, these formats are used.

• boolean - true;false
• integer - no default format, the complete string is parsed to integer (leading zeros possible and will be removed)
• number - 4 digits
• percentage - 2 digits
• currency - 2 digits
• date - yyyy-MM-dd
• datetime - yyyy-mm-dd hh:mm:ss

...

Output formats in the runtime. 

Functions

• boolean - true;false
• integer - no default format, the complete integer is set as string (no leading zeros)
• number - rounded to one digit
• percentage - rounded to one digit
• currency - rounded to one digit
• date - yyyy-MM-dd
• datetime - yyyy-MM-dd hh:mm:ss

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

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

You can adjust how the runtime displays these datatypes by adding a language-formats.properties file to the aquima.home folder. Such a file may look like this:

integer=default-integer-format
number=default-number-format-dot-2d
currency=default-currency-format-dot-2d
percentage=default-percentage-format-dot-2d
date=default-date-format
datetime=default-datetime-format
boolean=default-boolean-format

...