Alteryx Designer Desktop Discussions

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

changing date to a different format Quarter wise

Tid14
8 - Asteroid

Hi, I am working on a Workflow where i have date column mentioning dates as:

Date

03-31-2020

06-30-2020

09-30-2020

12-31-2020

 

I want to convert that into quarter periods in mm/dd/tu format

01/01/2020 - 03/03/2020

04/01/2020 - 06/30/2020

07/01/2020 - 09/30/2020

 

Looking forward for your suggestions

Thanks:)

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @Tid14 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1633095681838.png

 

Hope this helps : )

messi007
15 - Aurora
15 - Aurora

@Tid14,

 

Please see below :

 

messi007_0-1633095442183.png

 

Attached the workflow,

 

Regards

 

Nanoq
8 - Asteroid

@Tid14 this should do the trick - i made it dynamicaly find the start and the end of the quarter

Nanoq_0-1633097819079.png

 

Labels