The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at http://knime.com.

Preset Date/Time

Sets a default date or time to those timestamps where the date or time is not yet set.

Dialog Options

Column containing date/time
Select the input column containing date/time stamps.
Use date
Check and enter a date that should be set into those timestamps which do not have a date yet. If a date is already set it is not overwritten.
Use time
Check and enter a time to set this time into those timestamps which do not yet have a time set.
Replace missing values
Check if missing values should be replaced with the entered date/time

Ports

Input Ports
0 Table containing timestamp cells.
Output Ports
0 Table containing the preset timestamps.
This node is contained in KNIME Time Series Nodes provided by KNIME GmbH, Konstanz, Germany.