GetAsBoolean

Returns 1 (true) if data converts to a non-zero numeric value or a container field holds data; otherwise, returns 0 (false).

Format 

GetAsBoolean ( data )

Parameters 

data - any text, number, date, time, timestamp or container expression, or a field containing text, a number, date, time, timestamp or container

Data type returned 

number

Originated in version 

8.0

Description 

Returns a Boolean value.

Notes 

  • When an expression results in an error, it returns "?." GetAsBoolean evaluates "?" as 1 (true).

Example 1 

GetAsBoolean ( "" ) returns 0.

GetAsBoolean ( "Some text here." ) returns 0.

GetAsBoolean ( Container Field ) returns 1 when the field named Container Field contains data, or returns 0 when Container Field is empty.