cancel
Showing results for 
Search instead for 
Did you mean: 

Null dates in the Record Selection

Former Member
0 Kudos
94

HI we have some dates that are NULL value.

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

View Entire Topic
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