Date not converted correctly

[JM39]

Hello everyone

I'm trying to convert a date format. My input data has the format dd/mm/yyyy and I'm trying to convert to yyyy/mm/dd. I've set the date pattern in my input and output tmap to the formats mentioned but it's converting the year wrong. Example:

Input is 09/02/2021 (dd/mm/yyyy)

Output is 0021/02/09 (yyyy/mm/dd)

Not sure what I'm doing wrong. Thanks in advance

[Anonymous]

Hi

both of the data type of input/output should be date type, and the date pattern should be "dd/MM/yyyy" and "yyyy/MM/dd".

 Note: MM means month in year, mm means minutes.

Regards

Shong

[JM39]

Hi, thanks for that. Yes, sorry, that's exactly what I have done.

Input is date type, "dd/MM/yyyy"

Output is date type, "yyyy/MM/dd"

But when I look at the output, the date shows 0021 for the year instead of 2021.

[JM39]

Actually found the issue! My source data is in excel and the dates were showing as dd/MM/yyyy, but the actual format when I opened it in notepad was M/d/yy