Date&Time Shift


The node shifts a date or time with a defined duration or granularity. The user can select the Date&Time columns to shift and the shift value. The shift value can be achieved by using either a duration column or a numerical column, however, it is also possible to enter a constant shift value (either duration or numerical combined with a granularity). If the shift value is positive, it is added to the selected date. A negative value will be subtracted. A numerical value is interpreted based on the selected granularity (year, month, week, day, hour, minute, second, millisecond, nanosecond).

Input Ports

  1. Type: Data Input table.

Output Ports

  1. Type: Data Output table with shifted columns.

Find here

Other Data Types > Time Series > Manipulate

Make sure to have this extension installed: