Hi All, I have one source which is in date format, and some of the value inside the column is null. I try to map into a target with the same datatype, however it prompt me out an error while I try to "Exception in component tMSSqlOutput_1 java.sql.SQLException: Only dates in the AD era are accepted.at net.sourceforge.jtds.jdbc.DateTime.<init>(DateTime.java:111)" It will be ok if I try to put this query inside the filter: row1.column_name == null? TalendDate.parseDate("yyyy-MM-dd","1900-01-01"):row1.column_name.compareTo(TalendDate.parseDate ("yyyy-MM-dd","1900-01-01"))>0?row1.column_name:TalendDate.parseDate("yyyy-MM-dd","1900-01-01") is the date format cannot be null when i try to use the etl? Regards, Fuzaimi
