mattcasters opened a new pull request, #8257: URL: https://github.com/apache/hop/pull/8257
Fixes #2584 The Calculator transform can convert JD Edwards Julian dates (`CYYDDD`) to and from Hop dates, so this no longer needs a JavaScript workaround. Two new calculations appear in the Calculator **Calculation** dropdown: - **Date A to JDE Julian (CYYDDD)** (`DATE_TO_JDE_JULIAN`) → Integer - **JDE Julian A (CYYDDD) to Date** (`JDE_JULIAN_TO_DATE`) → Date `CYYDDD` matches the sample from the issue: - **C** = century relative to 1900 (`0` = 1900–1999, `1` = 2000–2099) - **YY** = two-digit year - **DDD** = day of year (`001`–`366`) Examples: `95001` is 1995-01-01, `109001` is 2009-01-01, `111013` is 2011-01-13. Five-digit values such as `95001` are accepted. Julian input can be Integer, Number, or String. Years before 1900 and invalid day-of-year values raise an error. Also includes user-manual entries, sample pipeline `calculator-jde-julian.hpl`, unit tests, and an integration test. Calculator module tests and `apache-rat:check` passed locally. Full `mvn clean install apache-rat:check` was not run locally. ------------------------ - [x] Mention the appropriate issue in your description (for example: `addresses #123`), if applicable. - [x] I hereby declare this contribution to be licensed under the [Apache License Version 2.0, January 2004](http://www.apache.org/licenses/LICENSE-2.0) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
