i have a file with 2 columns, strings, format 2-Nov-09.
columns imported straight from excel csv where they are recognized as dates.
i would like to use the time difference node to calculate the time difference between the 2 columns, but knime does not recognize the values as dates.
also not with the sting to date/time node. that node reaches maximum number of fails - "date format incorrect ?". I have tried different time formats, but it does not help.
what happened was this: the pull down in the node had only dd-MM-yy available.
looking at your answer i realized that i could actually type something in the box [ = i interpreted the drop down menu as a restricted choice list]. all i had to do was to type in the extra "M"...
Hi,
i have a question about Date&Time Difference node. I have to calculate the difference between one date and 10 other, so i would like to fix the first an then (i uesed a loop) calculate the difference. It doesn’t work. Can somebody explain me how to use this node in that circumstance?