COMO CAMBIAR UNA FECHA QUE VIENE EN EXCEL EN FORMATO TEXTO QUE SE MUESTRA COMO UN NUMERO '44075' A FORMATO FECHA EN KNIME?

[mlauber71]

@MSteven0420 welcome to the KNIME forum.

I hope this thread might help you. There also is a sample workflow that shows the conversion of an excel string into a date format:

Noob Help: Convert date value to dd/mm/yyy

Great - there’s the magic secret… according to this the epoch is new year’s day 1900, and each number is a day since. You could use the date & time shift node - but that seems like a pain in the ass. Here’s a workflow. Perhaps you could export the dates in a different format (like an YYYYMMDD string or milliseconds since epoch or …) for which there are nodes that do this conversion specifically. plunket excel number to date.knwf (6.8 KB)

convert excel number (or string) to date – mlauber71

strange enough this shift at the moment ends up with converting

44075 to the 3rd of sept 2020 instead of the 1st …