3 Replies Latest reply: Feb 6, 2013 9:40 PM by Hugo Sheng RSS

    Working with Nil Dates in Expressor

    Jamie Hicks

      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:

       

      input.Discharge_Date >=string.datetime("2010-01-01","CCYY-MM-DD")

       

      The filter fails because there are nulls in the Discharge_Date field. How do I avoid that?