topic Re: TalendDate.formatDate - Incorrect Year result in Talend Studio

TalendDate.formatDate - Incorrect Year result

hgromek — Mon, 22 May 2017 15:40:12 GMT

Hi! I use TalendDate.formatDate to pull the Year out of a Date however for all December dates in 2015 (i.e 2015-12-29) it is assigning a 2016 year? how is this happening, how can I fix it?

Re: TalendDate.formatDate - Incorrect Year result

Anonymous — Mon, 22 May 2017 16:23:31 GMT

Can you show us your code?

Re: TalendDate.formatDate - Incorrect Year result

hgromek — Mon, 22 May 2017 17:46:37 GMT

TalendDate.formatDate("YYYY",row1.ship_date)

Re: TalendDate.formatDate - Incorrect Year result

Anonymous — Mon, 22 May 2017 17:52:59 GMT

This *could* be a timezone calculation issue. Try using formatDateInUTC and see if that solves your issue.

Re: TalendDate.formatDate - Incorrect Year result

Anonymous — Mon, 22 May 2017 17:57:25 GMT

Actually forget that, the problem is your "YYYY". It should be "yyyy". Try that. This should explain it .....

http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

Re: TalendDate.formatDate - Incorrect Year result

cterenzi — Mon, 22 May 2017 21:04:50 GMT

For those not accustomed to reading Java documentation, "Y" in Java's SimpleDateFormat indicates "Week year" which extends the start of a year to include the entire week. Borrowing the example of 2015-12-29 (a Tuesday), this date evaluates to 2016 because 2016-01-01 (a Friday) is in the same week.

The results can vary depending on the calendar in use and the start day of the week (Monday vs. Sunday).

In short, use 'y' for years unless you have a very specific need.