cancel
Showing results for 
Search instead for 
Did you mean: 

Date Field Null Filtering

Former Member
0 Kudos

I am reasonably new to CR's and I am trying to only display data that has no entry in a date field.  I appreciate any advice or assistance.

Mike

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Michael,

Go to Report > Selection Formulas > Record and use this code:

{date_field_in_database} = cdate(0,0,0) or isnull({date_field_in_database})

Let me know if this works!

-Abhilash

Former Member
0 Kudos

That worked!  Thanks so much.

abhilash_kumar
Active Contributor
0 Kudos

Glad it works Michael!

Please do not forget to mark the thread as Answered.

Take care.

-Abhilash