Alteryx Designer Desktop Discussions

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

Date Pattern

Tim6
8 - Asteroid

Hi There, 

 

I have a start date and i would like the start date to repeat every month. 

For example :

Start Date: March 2 2019 

repeating dates: April 2 2019, may 2, 2019 etc

 

Is there a way i can do this using the multi row formula tool? 

Please let me know. 

 

Thank you,

2 REPLIES 2
PhilipMannering
16 - Nebula
16 - Nebula

Hi @Tim6 

 

Something like this might help. See attached.

PhilipMannering_0-1615828881333.png

 

danilang
19 - Altair
19 - Altair

Hi @Tim6 

 

Using a multirow tool will work, but you need to have existing blank records to fill.  If you only have the start and end dates, you can use a generate rows tool to create these new records for you.

 

danilang_0-1615831543913.png

 

Dan

 

 

 

 

Labels