Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

Alteryx Designer Desktop Discussions

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

Create Quarter End Date

ll98
9 - Comet

I have a workflow that creates Q1 Q2 Q3 Q4 -- respectively -- but I want to create a formula which will do 

 

if Year 2002  Q1 -- 3/31/2002 and so forth ..

 

The WF pulls the YEar and the quarter -- but need to create the Quarter end Date

 

 

3 REPLIES 3
mot
11 - Bolide

Hi @ll98 ,

 

One possible way is to use Summarize tool and max(Date) and group by Quarter. Best.

ll98
9 - Comet

Thanks -- I thought about that -- but Im thinking if my dates will not equal a quarter end date -- for instance if my last day of the Quarter End Date is 6/30/CCYY  and the last GL Data is 6/29/CCYY....  

mot
11 - Bolide

Hi @ll98 ,

 

In that case you can use the formula DateTimeTrim([Field1],"lastofmonth"). Best.

Labels
Top Solution Authors