Lengths of time between rows in a table that can be more than one row apart

[aworker]

Hi @hhaw

May be this other related post could help you to find a solution to your question:

Joining two tables based on date ranges

Hi @ViTLe My pleasure to help Joining tables by -date ranges- is not something trivial at a first glance so I understand the difficulty to get to a solution Please find below a possible solution. The -Sorter- node is not stricty needed appart from easing the understanding of the results. The Chunk Loop is neither strictly needed but it will help you to optimize the use of your computer memory if you have huge tables as you said. Otherwise, it could be done without it. …

In the above post, a workflow shows how to convert the dates into absolute integer numbers which allows to easily compare dates and know which ones are the closest.

Hope this helps.

Best

Ael