Alteryx Designer Desktop Discussions

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

Creating a date column

Tim6
8 - Asteroid

I am trying to reflect the same date of the month throughout the year.

Say the start date in Jan 15 2021

i want the next date to  be

- Feb 15 2021

- March 15, 2021

- April 15 2021 and so forth until the end of the year. 

Can you kindly advise how i can do this.

 

Thank you

4 REPLIES 4
ArtApa
Alteryx
Alteryx

Hi @Tim6 - Hope the attached example will give you an idea:

 

ArtApa_0-1642565673680.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @Tim6 

 

Here is my take.

 

Workflow:

atcodedog05_0-1642572663303.png

 

Hope this helps : )

 

Tim6
8 - Asteroid

Hi there is there a way to make bi weekly dates in alteryx? similar to above but just biweekly?

 

atcodedog05
22 - Nova
22 - Nova

Hi @Tim6 

 

Will this meet your requirement.

 

Workflow:

atcodedog05_0-1642661166152.png

 

Hope this helps : )

 

Labels