Reference > Functions reference > Logical functions > GetAsBoolean
 

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.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields
Using operators in formulas