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