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
...
| 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 | ||||
|---|---|---|---|---|
|
| Include Page | ||||
|---|---|---|---|---|
|
| Include Page | ||||
|---|---|---|---|---|
|
| Include Page | ||||
|---|---|---|---|---|
|
| Include Page | ||||
|---|---|---|---|---|
|
| Include Page | ||||
|---|---|---|---|---|
|
| Include Page | ||||
|---|---|---|---|---|
|
| Include Page | ||||
|---|---|---|---|---|
|
Output formats in the runtime
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]) |
- value - The value of the date type that is converted.
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