Expression Editor Functions - Convert Category

Function

Description of Returned Value

Bin

Converts a binary string representation to a number.

Format: Bin(text)

Date

Converts a value to a date.

Format: Date(value)

Empty

Returns an empty value.

Format: Empty()

Error

Converts a value to an error.

Format: Error(value)

Hex

Converts a hexadecimal string representation to a number.

Format: Hex(text)

Logical

Converts a value to logical.

Format: Logical(value)

Number

Converts a value to a number.

Format: Number(value)

Oct

Converts an octal string representation to a number.

Format: Oct(text)

Text

Converts a value to text.

Format: Text(value)

UOMConverter

Converts a value in one unit of measure to another unit of measure. A conversion factor must exist between the two units of measure.

Format: UOMConverter(fromUOM, toUOM, fromValue)

Example: UOMConverter("g", "kg", 2500)

Value

Returns a number from a date or number string.

Format: Value(string)