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 |
tgb417
2
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...
:)