Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Add an OR statement to your script:
ClosedDateTime>= '05/01/2017' OR IsNull(ClosedDateTime)
Add an OR statement to your script:
ClosedDateTime>= '05/01/2017' OR IsNull(ClosedDateTime)