CONVERT
Usage
Use this function to convert a value into a different type. Date type requires a third parameter which specifies the format of the date itself. Formats use the ISO 8601 standard
Category | Function | Type | Where to use | Argument statement |
---|---|---|---|---|
FUNCTION | SERVER ROW | CONDITIONAL | .VALUE |
Syntax
1 |
|
Arguments
Value
any cell value (#Storage_Name.Field_Name.VALUE
or .OLDVALUE
), constant, System Variables or function-returned value in any of datatypes available in eLegere
Data_Type
the resulting conversion datatype of those available in eLegere (DATE
, NUMERIC
and TEXT
- also lowercase is allowed)
Format (optional)
format use the ISO 8601 standard. It's useful only for date
Return Value
Value
Examples
Example 1
Formula
=CONVERT("2017/12/01"; "DATE"; "DD-MM-YYYY")
Description
We performed this formula in a date field type where we want to convert 2017/12/01 in DATE type with format days-month-year (separated by dash)
Result
01-12-2017
Example 2
Formula
=CONVERT("0001"; "NUMERIC")
Description
We performed this formula in a numeric field type where we want to convert 0001 in NUMERIC type
Result
1
Example 3
Formula
=CONCAT(#StorageExample.Identity.VALUE;
"-";
=CONVERT(#StorageExample.Date.VALUE, "TEXT", "DD-MM-YYYY")
)
Description
We permormed this formula in a string field type where we want to concatenate (CONCAT function) the cell values of the field Identity in the StorageExample with symbol - (dash) and convert the cell values of the field Date in the StorageExample in TEXT type format with with format days-month-year (separated by dash)
Result
1 - 01-12-2017