Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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