Empty()

Working with Formulas > Functions Used in Formulas > Other Functions > Empty()

EMPTY() determines if a record has a null or empty value.  EMPTY() works on all field types.  With character field records that are null, contain no content, or are composed only of spaces, the function returns false.  For numeric field records that are non-null and contain a value other than zero, the function returns false.  For Boolean field records that are non-null and contain true, the function returns false.  For date field records that are non-null and contain a date other than 00/00/0000, the function returns false.  For all other values (i.e. empty ones), the function returns true.

Function Format

EMPTY(value) 

Return Value

EMPTY() returns a Boolean value

Examples

EMPTY("ABC") = FALSE

EMPTY(Date(2000, 1, 1)) = FALSE

EMPTY(123) = FALSE

EMPTY("") = TRUE

EMPTY(" ") = TRUE

EMPTY(0) = TRUE

EMPTY(false) = TRUE

EMPTY(date(0,0,0)) = TRUE