GetAsBoolean
Purpose 
Returns 1 if data converts to a non-zero numeric value or if a container field contains data; returns 0 if data has a numeric value of 0 or is empty.
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 
FileMaker Pro 8.0
Description 
Returns a Boolean value.
Examples 
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