Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Conversion of Dates to Quarter

vrajgopal
7 - Meteor

Hi All,

 

I am trying to convert the dates in my data set to quarter. Created a formula based on various solutions provided in discussion group and am not getting the desired output. Can somebody have a look and let me know where I am going wrong.

 

Data set and Workflow is attached for reference.

 

regards

Vish

2 REPLIES 2
grossal
15 - Aurora
15 - Aurora

Hi @vrajgopal,

 

you formula looks very unclear to me, therefore I went with a clean approach:

 

grossal_1-1587820375254.png

 

Result: 

 

grossal_2-1587820386453.png

 

(Your result is still included for comparison purpose).

 

Workflow attached. Let me know what you think.

 

Best

Alex 

vrajgopal
7 - Meteor

thanks it works perfectly

Labels