Reference > Functions reference > Logical functions > GetAsBoolean


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


GetAsBoolean ( data )


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 


Originated in 

FileMaker Pro 8.0


Returns a Boolean value.


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