...
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
...
Function | Description |
---|
TEXT | Converts a value of another data type into a string. |
INTEGER | Converts a value of another data type into an integer. |
NUMBER | Converts a value of another data type into a number. |
CURRENCY | Converts a value of another data type into a currency. |
PERCENTAGE | Converts a value of another data type into a percentage. |
DATE | Converts a value of another data type into a date. |
DATETIME | Converts a value of another data type into a datetime. |
BOOLEAN | Converts a value of a string into a boolean. |
Output formats in the runtime.
Functions
Include Page |
---|
| Conversion function TEXT |
---|
| Conversion function TEXT |
---|
|
Include Page |
---|
| Conversion function INTEGER |
---|
| Conversion function INTEGER |
---|
|
Include Page |
---|
| Conversion function NUMBER |
---|
| Conversion function NUMBER |
---|
|
Include Page |
---|
| Conversion function CURRENCY |
---|
| Conversion function CURRENCY |
---|
|
Include Page |
---|
| Conversion function PERCENTAGE |
---|
| Conversion function PERCENTAGE |
---|
|
Include Page |
---|
| Conversion function DATE |
---|
| Conversion function DATE |
---|
|
Include Page |
---|
| Conversion function DATETIME |
---|
| Conversion function DATETIME |
---|
|
Include Page |
---|
| Conversion function BOOLEAN |
---|
| Conversion function BOOLEAN |
---|
|
Please see the Reference Guide: Language Formats to change how the runtime displays attributes.
Code Block |
---|
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]) |
Code Block |
---|
INTEGER(string, [format], [locale])
INTEGER(number)
INTEGER(currency)
INTEGER(percentage)
INTEGER(boolean) |
Code Block |
---|
NUMBER(string, [format], [locale])
NUMBER(integer)
NUMBER(currency)
NUMBER(percentage)
NUMBER(boolean) |
Code Block |
---|
CURRENCY(string, [format], [locale])
CURRENCY(integer)
CURRENCY(number) |
Code Block |
---|
PERCENTAGE(string, [format], [locale])
PERCENTAGE(integer)
PERCENTAGE(number) |
Code Block |
---|
DATE(string, [format])
DATE(dateTime) |
Code Block |
---|
DATETIME(string, [format])
DATETIME(date) |
Code Block |
---|
BOOLEAN(string, [format]) |
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.