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.