how cambiar numero a datatime ?

[gonhaddock]

Hi @carlos89 and welcome to the KNIME forum

You can find in this recent @takbb 's post, some insights for your challenge

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…

BR