Loop Time Calculation

[Gabriel2020]

Good morning everyone, how are you?

I’m having a lot of cases of broken vehicles at my shipping company. I need to identify the time they have between one shipment and another.

So, as in the image, I need to check the red with the red, then the green with the green and so on.

It will have to be done in a loop because I have other plates included, I’ll send a print and the workflow below.

I need the difference in days between one and the other, ok?

Red example:

ETA_Destination: 2025-02-03

ETA_ORIGIN: 2025-02-09

DIF: 06

Green example:

ETA_Destination: 2025-02-13

ETA_ORIGIN: 2025-02-17

DIF: 4

KNIME_project.knwf (2.8 MB)

[rfeigel]

I’m confused. There doesn’t appear to be any dates in the workflow you uploaded.

[Gabriel2020]

Sorry I uploaded the wrong file

Loop Date.knwf (17.2 KB)

[Gabriel2020]

@takbb Can you help me with this topic please?

[rfeigel]

I assume you want to do these calculations for each vehicle separately? Is that correct? Based on this assumption, try this.

Loop Date – rfeigel