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
Was this topic helpful? Send feedback.