Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

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