Allowing Nulls for Date Time field

[stevejones1]

Hi

I have a field "ClosedDateTime" , which has Nulls and Date time values

I need to filter the values above 05/01/2017 but when i use ClosedDateTime>= '05/01/2017' in the script its removing all the rows where

ClosedDateTime is Null also .. i want to have nulls at the same time filter dates by date

How do i do that?

Thanks!

[Nicole-Smith · Accepted solution]

Add an OR statement to your script:

ClosedDateTime>= '05/01/2017' OR IsNull(ClosedDateTime)