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
Date(Max(DateField),'DD-MMM-YYYY') or Date(QuarterEnd(Max(DateField)),'DD-MMM-YYYY')
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
Do you have DateField created?
If yes, Date(QuarterEnd(Max(DateField)),'DD-MMM-YYYY')
for ur date filter :
try it and tell me what happens
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)?
Retrieving data ...