0 ×

Modify Date

StreamableKNIME Date and Time Handling version 4.4.0.v202106241857 by KNIME AG, Zurich, Switzerland

Modifies date&time columns in three different ways. The node can append a date to local time columns (output type is local or zoned date time column) or change the date in local or zoned date&time columns or remove the date from local or zoned date&time columns (output type is local time).
This node is not used to add ("plus") or subtract ("minus") date. Use the Date&Time Shift node for that.


Column Selection

Column Selector
Only the included columns will be modified.

Replace/Append Selection

Append selected columns
The selected columns will be appended to the input table. The suffix of the appended columns can be provided in the text field to the right.
Replace selected columns
The selected columns will be replaced by the new columns.

Date Selection

Append Date
Appends a date to local time columns. Optionally a time zone can be appended too.
Change Date
Changes the date of local or zoned date&time columns. The time zone will not be changed. The Modify Time Zone node can be used to change it.
Remove Date
Removes the date from local or zoned date&time columns. Time zones will be removed too.
A date value in form of yyyy-MM-dd.
Time Zone
If checked, the user can choose the time zone to append also.

Input Ports

Input table.

Output Ports

Output table with modified date.

Best Friends (Incoming)

Best Friends (Outgoing)



To use this node in KNIME, install KNIME Base nodes from the following update site:


A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.


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.