Date&Time to SerialNumber

Takes a datetime column and returns the date serial number according to one of the selected serialization options

Updated April 2024 - allow Local Date column as well as Local Date&Time
@takbb Brian Bates 20 October 2023

Options

Choose Date&Time column
Specify the Date&Time column to convert. An unzoned Local Date Time value will be treated as UTC
Serial Date to return
Enter the serialized date to return. The Excel date incorporates the "excel bug", so dates start with 1 at 1 Jan 1900 up to 28 Feb 1900 which is day 59 and then continue at 61 for 01 March 1900. The non-existent 29 Feb 1900 is day 60.
Output Column Name
Specify the column name to output

Input Ports

Icon
Table containing at least one Local Date&Time or Local Date column

Output Ports

Icon
The original table plus an additional column containing the serialized date value

Nodes

Extensions

Links

Download

To use this component in KNIME, download it from the below URL and open it in KNIME:

Download Component
On NodePit since: 2023-10-21
Last update: 2026-01-19
Created with KNIME version: v4.7.8

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!