Date Rounder

Rounds date columns to a specified granularity. You can adjust date values according to user-defined rounding strategies and precision, and replace or append the rounded values to the input table.
Frequently used to align dates to the start of months, quarters, or years for reporting and grouping.

Options

Date&time columns

The date&time columns whose values are shifted.

Round to

The rounding strategy to apply, either round to the first or last value of the chosen rounding precision.

Exclude weekends

Option to exclude weekends from the rounding. A weekend is defined as Saturday and Sunday.

Additional shift

Option to shift the date to the previous or next date in the chosen resolution.

• Previous: Shifts to the previous value. 12.12.24 rounded to the first day of the 'previous' month will result in 1.11.24.
• This: Shifts to the this value, i.e., no shift at all.
• Next: Shifts to the next value. 12.12.24 rounded to the first day of the 'next' month will result in 1.1.25.

Rounding precision

The rounding precision. The date will be rounded to the first or last value of the chosen precision.

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.

Views

This node has no views

Workflows

• No workflows found

Links

• No links available

Developers