Create Quarter End Date

[ll98]

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

[mot · Accepted solution]

Hi @ll98 ,

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

[ll98]

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 · Accepted solution]

Hi @ll98 ,

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