Mapping Error : DateTrans

[Former Member]

Hi All,

Requirement of Data is to convert "YYYY-MM_DD" to "YYYYMMDD".

It is working fine by using "DateTrans" for every value, but when try to send "0000-00-00", giving "00021130" a default value.

What should do for sending the same value?

Thanks,

Arthita

[Former Member]

Hi Arthitha,

Check with an If-Else.

1. If Date is 0000-00-00 then map with default as 00021130

2. Else transform the date as per what you have done above.

Regards,

Sriram

[Former Member]

Hi Arthita,     You should add a If case, when the value is: 0000-00-00 then the same: "0000-00-00" else, the date trans. Regards.

[sateesh_adma]

Hi arthita,

please look this