Date Shifter - how to pass a negative day shift in a flow variable?

KNIME Analytics Platform
7

Oh! Since you can enter negative values directly into the Shift value field, this looks like a bug to me. I opened a ticket (internal reference AP-25311).

For now, a 5.8 workaround might be to append a column with the value from the variable using Constant Value Column – KNIME Community Hub and than using that column in the Date Shifter.

For 5.5, I would recommend an expression-based solution as suggested by @ActionAndi using

add_date_duration($[“Date”], parse_date_duration($$[“delta_str”]))

Thanks for reporting,

nan

3 Likes