How to use Null Values to find missing dates in a field

[#1]

I a termiation date in the script I built.  What I am wondering if there is a way to find only those records where the termination date has data. 

[erichshiino]

Hi,

I would create a flag in script.

Let us say that your script is:

Load Invoice, Termination

From/Resident someTable...

You can create a flag like this:

Load Invoice, Termination, if( isnull(Termination), ,1,0) as flagDateExists

From/Resident someTable

Then, in a sheet, you can include this field ( flagDateExists) and select one to identify records without termination date

Hope it helps,

Erich

[rlp · Accepted solution]

Another possibility is to "Select Possibles" in the field, which exclude all NULL values.