Page History
...
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
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]) |
- 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”.
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.
Overview
Content Tools