Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Date and Quarter Fomula through Months

Learner09
8 - Asteroid

Hello All,

 

I am trying to make a formula for Year and Quarter through the month. Please see the attached file for details and advice. 

 

Thanks,

4 REPLIES 4
messi007
15 - Aurora
15 - Aurora

@Learner09,

 

Please see below:

 

messi007_0-1613032466727.png

Attached the workflow,

 

Regards

Learner09
8 - Asteroid

Hello, @messi007 Thanks for the flow,  Fiscal year looks good as "Fiscal 2021" but the Qtr need some adjustment, I wanted the Quarter as "Qtr 1, 2021".

messi007
15 - Aurora
15 - Aurora

@Learner09,

 

Below the update:

messi007_0-1613034297729.png

Attached the new workflow.

If it solve the problem please mark it as solved it will help others 🙂

 

Regards,

Learner09
8 - Asteroid

@messi007 Thank you!

Labels
Top Solution Authors