How to retrieve Month part of a Date returns previous Month instead. Bug?

[elkhounds]

The TalendDate.getPartOfDate("MONTH", " ") method returns the previous month instead of the current month. Is this a known bug? I need to identify the current and previous months of a date, but this method does not work as expected.

In this example, the returned month should October (10), but  TalendDate.getPartOfDate("MONTH"," ") returns September (9).  See attached file

[elkhounds]

Here is the link:

https://help.talend.com/reader/EJfmjmfWqXUp5sadUwoGBA/zYNMH6bBDXOsbdPl8zw11g

[Anonymous]

Hi @elkhounds 

     Good catch and I also got the same result when I tried to run it in Talend 7.2

I have reported the Bug to the Product Team through JIRA. Please use the link below to track the progress of this ticket.

https://jira.talendforge.org/browse/TDI-43350

Appreciate again for identifying the issue 🙂

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

[PhilHibbs · Accepted solution]

I have encountered date libraries before that return the month using a zero-based index, so 0 is January and 11 is December. This may not be a bug. Existing code that relies on this behaviour would be broken if this were changed.

The java.util.Calendar class specifically has this behaviour:

https://docs.oracle.com/javase/7/docs/api/java/util/Calendar.html

MONTH

public static final int MONTH

Field number for  get  and  set  indicating the month. This is a calendar-specific value. The first month of the year in the Gregorian and Julian calendars is  JANUARY  which is 0; the last depends on the number of months in a year.

See Also: JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER, UNDECIMBER, Constant Field Values