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")
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy