I need to filter on a date field that contains null values. The schema is a table schema against a table in teradata. I tried to edit the schema by not allowing Null values on that date field, and then setting the default value to 2000-01-01. The Schema accepted 2000-01-01 as valid, but when I run the dataflow, 2000-01-01 is rejected.
Here is the filter logic that I am using against the date field: