How to convert numbers to date and time

I have this string of number 40885.543055556 and I want to convert them to dates in knime. I have been trying to find for answers but to no avail. I tried the date&time shift node but it isn’t working.
The ones I hve filtered out are the correct ones but the unfiltered ones are numbers

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.


Thank you so much! Your explanation is so clear.

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.