HOW TO GET ALL DATES BETWEEN A RANGE

[closer1]

Hi, I’ve a workflow with many ‘start/end dates’ combinations

I need to have 1 line for each one of the days between these.
Example: In row 1 it is “12/8 to 12/10” so the output should have 3 rows: “12/8”, “12/9”, “12/10”.
Dates Between.xlsx (4.0 KB)
In row 2 it is “12/22 to 12/24” so it should have other 3 rows.
The final output should be like:

[lelloba]

Hi @closer1 ,

have a look at this post:

passing dates variable to time generator

Good afternoon, I want the time generator to create all the dates between a start date and an end date dynamically (with start and end dates coming from variables). [image] When I enter inside node configuration I see there is no way to assign a variable for the start and the end date (while I can assign a variable to input the number of rows to be created). [image] Any suggestion?

Have a nice day,
Raffaello Barri

[closer1]

Hi Raffaello, thanks for your help
Link for other ppl:
LoopingOverDateRangesExample.knwf (102.3 KB)