Generate dates between [StartDate] and [EndDate]

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.

Start to End date.yxwz

Macros

Date Time

Accepted answers

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 😀👍

All comments

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 😀👍

Generate Rows can help

DateTime_Generate.yxmd

Thanks a lot!! it worked perfectly.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703