I have a sequence container and in that sequence container I have select that is passing through data into a foreach loop container. The problem arises with one of the columns that's a date datatype. When there is a date in that column it works fine, but when it's a null it fails. Is there anyway around this issue with null values?
This is the column
Below is the sql statement where I change the date from null to a date
cast(ISNULL([Submitted_Date],'01/01/1900') as datetime) as [Submitted_Date]
Application_Form_Id IN (12345)
processed = 0