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.