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