Create a Date based on the condition

[Subramanyam]

Hi Team,

I would like to create a column based on the condition between two input columns.
condition:
Nee to generate new date rows between Start month change date and End of month and
Date <= End of month.

Attached the Excel sheet with input columns and required output column.

Please help me in resolving the issue.

Thanks,
Subbu
Generate_Dates.xlsx (10.7 KB)

[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’…

[MartinDDDD]

Moved this from Job Board to KAP…

[alpayzeybek]

Hi Subramanyam

Can you please review the workflow below? Feel free to reach out if you have any questions or need clarification.

Best,

Alpay

DateStart&End.knwf (21.3 KB)

[alpayzeybek]

@Subramanyam
I’ve just updated my workflow — I realized that I had accidentally deleted an important node before posting it
Apologies for the oversight!

Best,
Alpay