Cannot convert a format using the Date/Time Formatting logic as expected

Question

I read date/time format data using the Read CSV File operation and then converted the format using the Date/Time Formatting logic, but the result was not as expected.
What is the cause and how can I solve it?

Answer

-Cause
The data read with the Read CSV File operation is treated as a string type.
Since the input handler of the Date/Time Formatting logic is specified as a date type, the result might not be output as configured.

-Solution
Please convert the string type data to a date type using the Parse Date/Time logic, and pass it to the Date/Time Formatting logic.

-Supplementary information
If the Date/Time Formatting logic does not convert the data properly even after using the Parse Date/Time logic, the Mapper column settings might be incorrect.
In this case, set the Mapper's schema again.

-References
[Date and Time Formatting]
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Mapper/Iso8601ToCustom.htm
[Parse Date/Time]
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Mapper/CustomToIso8601.htm