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