Generate dates between [StartDate] and [EndDate]

[preethisisaac]

Hi All,

I have attached my workflow where i am taking the [StartDate] and [EndDate] from interface tool and have stored in a text input tool. Now i want to generate all the dates between the StartDate and EndDate as rows in text input tool in another column. Please provide your suggestion.

Can i do this without a macro ? if macro, do i have to use iterative macro?

Please help me with take this forward.

[atcodedog05 · Accepted solution]

Hi @preethisisaac 

You can use generate rows tool to creates dates between 2 dates.

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[anjaliaithal]

Generate Rows can help

[preethisisaac]

Thanks a lot!! it worked perfectly.

[atcodedog05]

Happy to help 🙂 @preethisisaac 

Cheers and Happy Analyzing 😀