Splitting cell in multiple rows with continous date reference

Hi there,

I just got a very helpful answer to a relating topic, now its getting even more tricky.

I have a table with a column with regular content and in every row a start date and end date.
Is there a way to insert a new row for every date in between those start and end dates

  • to insert a columns with the runnig date
  • to copy the rest of the table to the new rows?

example - 5 columns - dates are european style

from here:

[A] [B] [C] [10.10.2018] [13.10.18]

to here:

[A] [B] [C] [10.10.2018] [13.10.18] [10.10.18]
[A] [B] [C] [10.10.2018] [13.10.18] [11.10.18]
[A] [B] [C] [10.10.2018] [13.10.18] [12.10.18]
[A] [B] [C] [10.10.2018] [13.10.18] [13.10.18]

Thank you for your help!

Hi @astrauch

This can be achieved with the Date&Time Difference and the Create Date&Time Range nodes.

I attached a workflow which does exactly that, see: date_range.knwf (53.3 KB)

1 Like

@oole you saved my day!

Thank you very much for your help!

Glad it did!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.