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

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
Top Solution Authors