Problem with date format

sg33 · Post by **sg33** » Wed Dec 14, 2011 11:11 pm

Hi ,

I have a parallel job with the source as a dataset .A field AMORT_DT is coming as VARCHAR from the input and is being converted to Date in the transformer . After the lookup I want to check the converted Date field for Empty field (i.e '')

I think '' is not a valid date type .

Is there any other way to look for Empty String .

Thanks in advance !!

kamtammystuff · Post by **kamtammystuff** » Thu Dec 15, 2011 12:04 am

Check the validity of the date before converting it into DATE datatype in the transformer itself.