Date Shifter

Shifts date columns by a defined duration or granularity. You can select the date columns to shift and specify the shift value as a duration column, a numerical column with a granularity, or a constant numerical value with a granularity. Positive values shift the date forward; negative values shift it backward. Numerical values are interpreted based on the selected granularity.
Often used to adjust timestamps to account for time zone differences or reporting periods.

Options

Date&time columns
The date&time columns whose values are shifted.
Shift mode
Select the shift mode to use.
  • Shift value: Uses a date-based shift value.
  • Period column: Uses a shift value from a date-based duration column.
  • Number column: Uses a numerical column to scale a configurable time unit.
Shift value
Select to insert a format string to use as constant shift value. The inserted string can be either in:
  • the ISO-8601 representation (see date-based duration format for details)
  • the short letter representation (e.g. '2y 3M 1d'). In this case, for the the letters y, M, and d respectively indicate years, months, and days.
  • the long word representation (e.g. '2 years 3 months 1 day').
Column
Select to choose the shift value from a date-based duration column.
Column
Select to choose the shift value from a numerical column. The shift value will be scaled by the selected granularity.
Granularity
The granularity (i.e. days, weeks, etc) of the shift.
Output columns
Depending on this setting, the output columns will either replace the modified columns, or be appended to the table with a suffix.
  • Replace: Replaces the selected columns by the new columns.
  • Append with suffix: Appends the selected columns to the input table with a new name that is the previous name plus the provided suffix.
Output column suffix
The suffix to append to the column names of the new columns.

Input Ports

Icon
Input table containing date&time columns.

Output Ports

Icon
Output table with shifted date.

Popular Predecessors

  • No recommendations found

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.