SOLVED
Generate dates between [StartDate] and [EndDate]
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
preethisisaac
8 - Asteroid
11-14-2020
11:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
4 REPLIES 4
22 - Nova
11-14-2020
11:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
7 - Meteor
11-15-2020
12:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
11-15-2020
01:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks a lot!! it worked perfectly.
22 - Nova
11-15-2020
01:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
