topic Re: Date not converted correctly in Talend Studio

Date not converted correctly

JM39 — Fri, 15 Nov 2024 23:50:41 GMT

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

Re: Date not converted correctly

Anonymous — Wed, 18 Aug 2021 04:45:13 GMT

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

Re: Date not converted correctly

JM39 — Wed, 18 Aug 2021 11:16:20 GMT

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.

Re: Date not converted correctly

JM39 — Wed, 18 Aug 2021 13:22:47 GMT

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