We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Get a detail date list between the Stating Date and Final Date

AMERINO
6 - Meteoroid

Hi all!

 

I'm sorry if this topic has been discussed previously, but I'm a new user on the page and I'm still adapting. I have tried to search the Alteryx community and I have not found it.

 

My Doubt is:

I start a flux with two dates ("Period start date" and "Period end date") I want to obtain a list with the whole dates between these two dates. 

I give an example to try to make clear what I want:

 

I have:

Start DateFinal Date
2017102820171107

 

I want:

List of dates
20171028
20171029
20171030
20171031
20171101
20171102
20171103
20171104
20171105
20171106
20171107

 

Thank you very much for your help!

 

2 REPLIES 2
DavidP
17 - Castor
17 - Castor

Here you go:

 

Workflow attached

 

generate dates.png

AMERINO
6 - Meteoroid

I didn't know "Generate Rows Tool"! thank you!

Labels
Top Solution Authors