Skip to Content
0
Mar 24, 2009 at 11:13 AM

Graphical mapping problem

36 Views

Hi All

I am using graphical mapping, and i have a problem.

I am mapping source date field to target date field (both fields are of type xsd:date, and both has occurance 0 to 1). My source value can be blank(null)

Initially It was a direct one to one mapping, and there was no problem.

But, when i use TransformDate function to transform source date format ddMMyyyy to target date format yyyy-MM-dd, i get the following error when there is no source value:

Unparsable date:""

I am passing a null value, but as the occurance is 0 to 1, shouldn't it take care of null source value?

Then, i changed the mapping as following:

If(source date) exists

then sorucedate -> TransformDate -> Targetdate

else constant "" -> Targetdate

Even with the above mapping, i get the same error: Unparsable date: ""

Can someone tell me what is going wrong here?

Thanks

Chandra