@lakshmi_narayanan_t 

In SDC , if the date filed is null from source it will replace with default date time value as like “1970-01-01” and it won’t allow us to load data to the destination.

In this case we need to filter those date fields and replace them with null and proceed further.

If you are having issues in converting the actual date time field , please let me know i will try to help you.

Provide me the sample date time field and also let me know the expected result , then i can give a try to help you on that.

Thanks & regards

Bikram_