In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Generate dates between [StartDate] and [EndDate]

preethisisaac
8 - Asteroid

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.

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @preethisisaac 

 

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

Here is a workflow for the task.

Output:

atcodedog05_0-1605427027951.png

 

Workflow:

atcodedog05_1-1605427038641.png

 

Hope this helps 🙂


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

anjaliaithal
7 - Meteor

Generate Rows can help

preethisisaac
8 - Asteroid

Thanks a lot!! it worked perfectly.

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @preethisisaac 

 

Cheers and Happy Analyzing 😀

Labels
Top Solution Authors