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

Nodes

• Column Filter5 ×
• Column Rename5 ×
• Date&Time Difference4 ×
• Math Formula4 ×
• CASE Switch End1 ×
• CASE Switch Start1 ×
• Column Appender1 ×
• Column Selection Configuration1 ×
• Component Input1 ×
• Component Output1 ×
• Modify Time Zone1 ×
• Single Selection Configuration1 ×
• String Configuration1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Math Expression (JEP)
• FeatureKNIME Quick Forms

Links

• No links available