How to get the maximum date for a specific quarter

[siddharthsoam]

I want to fetch the maximum date with respect to quarter selections. If I select quarter Q2 then it should give me the last date for that quarter. For example when I select quarter Q2 it should give me '31-Jul-2017'.

Please suggest me how to do it

[shraddha_g]

Date(Max(DateField),'DD-MMM-YYYY') or Date(QuarterEnd(Max(DateField)),'DD-MMM-YYYY')

[siddharthsoam]

Hi Shraddha thanks for coming once again

I want to return last date of quarter end with respective to selection in quarter filter. I have a quarter filter at frontend

[shraddha_g]

Do you have DateField created?

If yes, Date(QuarterEnd(Max(DateField)),'DD-MMM-YYYY')

[OmarBenSalem]

for ur date filter :

=aggr(max(total<quarter> date),date)

try it and tell me what happens

[Mark_Little]

Hi,

Not sure if i am over simplfiying this, but if you have your date field created and you want the date shown to be driven by selection would it not just be MAX(Date)?

Mark

[OmarBenSalem]