Time Difference Node: result is different comparing to excel calculation

Hi guys!

I have a dataset with invoices and a column with "date".

I want to calculate the difference between today and the date column and I used the Time Difference Node for that.

I couldn't figure out why the Knime result always shows 1 day of difference from excel calculation.

Am I doing something wrong?

DATE KNIME TIME DIFF EXCEL RESULT
21-1-2007  3630.0                      3.629,00
28-1-2007  3623.0                      3.622,00
4-2-2007  3616.0                      3.615,00
11-2-2007  3609.0                      3.608,00
18-2-2007  3602.0                      3.601,00
25-2-2007  3595.0                      3.594,00

Assuming that you are using the Excel datedif function it returns the number of full days.

https://support.office.com/en-us/article/Calculate-the-difference-between-two-dates-8235e7c9-b430-44ca-9425-46100a162f38

Partial days are set to 0

Knime node has lots of different rounding and granualrity options for time difference calculations.

This post might be helpful.

https://tech.knime.org/forum/knime-users/age

Others might know the exact settings to get exactly what MS Excel is doing.

I've made another calculation and its the same result now.

Strange things...

:)