Loop Time Calculation

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