[Feature Request]: Calculator - add Date generator

[dave-csc]

What would you like to happen?

In the Calculator transform there are many operations to get and modify the various parts of a Date (year, month, day of month, day of week, etc.), ma no operation to get a Date object from its parts (year, month, day of month).

It could be useful to add an operation like "Create Date from Year A, Month B and Day of month C": the time part can be defaulted to midnight (and then modified with the already existing operations "Date A + B hours/minutes/seconds").

The current workaround consists in using a User Defined Java Expression transform, and create a field of type Date with an expression like:
new java.util.GregorianCalendar(YEAR_FIELD.intValue(), MONTH_FIELD.intValue() - 1, DAY_OF_MONTH_FIELD.intValue()).getTime()
(beware of the -1 in the month field!)

Issue Priority

Priority: 3

Issue Component

Component: Hop Gui, Component: Transforms

[dave-csc]

Note: I updated the workaround, since the Integer value in Hop is actually a Long/long type in Java rather than an Integer/int