Null dates in the Record Selection

[Former Member]

HI we have some dates that are NULL value.

In the Record Select, how do I exclude such rows?

[abhilash_kumar · Accepted solution]

Hi Paul,

Open the Record Selection Formula and select 'Default Values for Nulls' from the drop-down on the top.

Next, use a code like this:

{Date field} <> date(0,0,0)

-Abhilash

[former_member205840]

Hi Paul,

Also you can try :

Not(Isnull({date}))

Thanks,

Sastry