Date Null Handling

[phanee_k]

Hi,
How to Handle the nulls on date fields using Handle_Null in modify stage.

I tried

Run_date = Handle_Null(Run_Date,'')
and
Run_date = Handle_Null(Run_Date,'0')

But the job is getting aborted due to this.

Thanks,
Phani

[kumar_s]

Try giving some low date.
0001-01-01. its a 'standard'

regards
kumar

[ray.wurlod]

If it's a Date data type, then the replacement value must be a date. And this must match your date picture (for example "%yyyy-%mm-%dd").