Alteryx Designer Desktop Discussions

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

Get list of dates from a range of date

Jes_Li
7 - Meteor

Hi everyone,

 

A simple question(but don't know how to achieve...). I have a start date and an end date. And using these 2 dates generates a list of dates. Just like below....

 

Please help if you have any ideas. Thanks!!!!

 

 

Screenshot 2020-09-11 101148.jpg

2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor

Hi @Jes_Li ,

 

You can use the cross tab + generate rows to create that range of dates, take a look.

fmvizcaino_0-1599796032535.png

 

 

BEst,

Fernando Vizcaino

ArtApa
Alteryx
Alteryx

Hi @Jes_Li - You can find a very detailed explanation in Designer example workflows:

 

ArtApa_0-1599807168452.png

 

Labels