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.