Conversion of Dates to Quarter

vrajgopal

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

Test.xlsx

Test quarter from dates.yxmd

grossal

Hi @vrajgopal,

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

Result: 

(Your result is still included for comparison purpose).

Workflow attached. Let me know what you think.

Best

Alex 

Test quarter from dates - updated.yxmd