IsNull()

Function reference
Test if the value of an expression is null.

IsNull ( expression )

Argument	Description
expression	An expression that you want to test to determine whether its return value is null

Data type: Boolean
Returns true if expression returns null.

Example:

The value ‘The sun is shining..’ is not a valid text representation for a date then the function Date() will return null.

IsNull( Date( ‘The sun is shining..’ ))

Last modified: 23 May 2021

Feedback