NOTNULL( )
Tests if a value in a specified data field is a non‑null value.
Syntax
NOTNULL(value)
Argument
value
The data field in which to check for non‑null values.
Returns
True if a value in the specified data field is not a null value; returns false otherwise.
Example
The following example uses NOTNULL( ) in conjunction with the IF( ) function to test for non‑null values in the BirthDate data field. If there is a non‑null value, the BirthDate value is displayed; otherwise the string “No date specified” is displayed.
IF(NOTNULL([BirthDate]), [BirthDate], "No date specified")