Create a Date based on the condition

[takbb]

Hi @Subramanyam

This can be achieved by calculating the number of days between each start and end date (and adding one to it to be inclusive), and using the One Row to Many node to create the rows between, then determining what the date for each row is by its relative position in the newly created set of rows.

Here is an example, along with other mechanisms (e.g. using a loop)

Create date range using dates in 2 columns

Hi @jepavila , as @iCFO said, @bruno29a’s approach can be adapted using a straightforward loop. In fact a Table Row to Variable Loop, in place of the Table Row to Variable should be all that is required. Achieving it without a loop is a little more convoluted, but can be done by calculating the number of rows required for each date range, creating rows and then calculating the individual dates for each row based on their offset from each starting date. [image] The attached contains Bruno29a’…