Require assistance in conversion from string to date

creatingfusion · Post by **creatingfusion** » Mon Sep 20, 2010 2:20 pm

I have a requirement where I have to get the value in the output field as '00000000' which is a date field. The requirement is to be done in the transformer and gets further into IDOC Sap Stage.

I tried the following function:
StringToDate("00000000","%yyyy%mm%dd")

It transforms and the output being "**********"

Please suggest some solution to this issue.

Thanks
ABhijit

anbu · Post by **anbu** » Mon Sep 20, 2010 2:26 pm

"00000000" is not a valid date. That is why you see asterisks in your target. Assign default date if the input has "00000000"

ray.wurlod · Post by **ray.wurlod** » Mon Sep 20, 2010 2:27 pm

"00000000" is not a valid date (there is no year 0, there is no month 0, there is no day 0). So don't try to convert it.