[Bug]: Issue with “month” function in JavaScript within Apache Hop – incorrect month number returned

[alexdesousapereira]

Apache Hop version?

2.12

Java version?

17

Operating system

Windows

What happened?

When using the month function in a JavaScript script in Apache Hop, the returned value does not match the correct month number. The date is being converted to an incorrect value.

Example:

Issue Priority

Priority: 3

Issue Component

Component: Transforms

[bamaer]

not incorrect, just zero based (January is 0, December is 11)

[alexdesousapereira]

Thanks!

[alexdesousapereira]

If anyone has any questions about how it works, follow the W3Schools documentation on JavaScript functions.

https://www.w3schools.com/jsref/jsref_setmonth.asp