Convert Date into 5 digits like in excel and vice versa

KNIME Analytics Platform
1

Hi Team,
as you can see that column A is date format and col B is Text format

I would like to seek for your advice on how to convert the date to 5 digits numbers like in excel when we change format of date to text and vice versa.
is there a node that can serve this purpose? if not, is there a way we can achieve this with combined nodes?

your advice is really appreciated

image

2

Don’t think there’s a node for that - try the following: use Date&Time Difference node and calculate the difference between 1/1/1900 and the date in your column… make sure you convert your dates from string to date using string to date and time node

3 Likes
3

In addition to Martin, here’s an extract from Microsofts Documentation
Quote:
** Excel stores dates as sequential serial numbers so that they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,447 days after January 1, 1900.*

So you need to enable the “days” granularity. (which is set by default)

4 Likes