DSXchange

Hi All,
I am trying to handle null in a Date (length 10) and timestamp (length 26) datatype columns in Modify Stage. I specified as follows:

Date1=handle_null(date2,'1111-11-11')
timestamp1=handle_null(timestamp2,'1111-11-11 11:11:11.111111').

This is not working. Any suggestions plz.

Try testing them one at a time and maybe put in there a string to date or string to timestamp function inside the null handler.