How to convert numbers to date and time

[takbb]

Hi @mercilessk

The numbers you have look like the excel internal dates. See the following post. It should contain all you need to know but please post back if you need any further assistance.

How do I convert String to datetime or how do I replace their values with one correct value from same ID

Hi @SoC, and welcome to the KNIME community! The decimal numbers in your InvoiceDate represent the elapsed time since 01 Jan 1900. There are 86400 seconds in a day and so if you multiply the number by 86400 you will get the number of seconds since 01 Jan 1900 So far so good. So we know we can find a way to convert the numbers. However, taking a step back, why do you have a mix of readable dates, and excel internal date values in the source data? I would suggest that the better option (if avail…