CONVERT
Converts values to a specific value type.
Syntax
CONVERT(value; valueType)
value - the value which should be converted - Value type: any
valueType - the value type to which value should be converted - Value type: constant Possible values are:
number
text
date
boolean
constant
Example
The left table contains the values of table1, converted to numbers. If a value cannot be converted to a number, !VALUETYPE is displayed. A boolean is converted to its number representative.