Originally posted by: SystemAdmin
Currently we are upgrading interfaces from version 1.4.2 and 6.5.2 to version 6.7.1.
My input is a text item, which contains a date in the fromat CCYYMMDD. The output should be again a text item, which has to contain the date in the format DD/MM/CCYY.
In version 6.5.2 I have used the rule:
=FromDateTime(ToDateTime(Date_In, "CCYYMMDD"), "{DD/MM/CCYY}")
This rule was working fine.
In version 6.7.1 the same rule returns NONE.
I have created a test-map, where the input is a text-item and the output is Date/Time item with the format CCYYMMDD.
When using the rule Date_Out=ToDateTime(Date_In, "CCYYMMDD") then the rule returns NONE.
I have tested the other way around as well, where the input is defined as date in the format CCYYMMDD and the output is defined as text. The rule Output=FromDateTime(Date_In, "{DD/MM/CCYY}") creates the expected output.
It's the function ToDateTime, which is not working properly.
My question is now: Is this a bug in version 6.7.1 or is the something wrong in the rule?
Kind Regards,
Joerg
#DataExchange#IBMSterlingTransformationExtender#IBM-Websphere-Transformation-Extender