cancel
Showing results for 
Search instead for 
Did you mean: 

Null dates in the Record Selection

Former Member
0 Kudos
91

HI we have some dates that are NULL value.

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

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

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

Answers (1)

Answers (1)

former_member205840
Active Contributor
0 Kudos

Hi Paul,

Also you can try :

Not(Isnull({date}))

Thanks,

Sastry