GetAsBoolean

GetAsBoolean

Purpose

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

FileMaker Pro 8.0

Description

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.