I want to get the last date of the respective month from the selected month name selected by a filter.
If a month is "Jun" , then I want it should appear as "30-Jun-2017".
If you have a DateField in Data Model then you can try
Create a Monthend Field.
Date(MonthEnd(Date#(Month &' '& Year,'MMM YYYY')),'DD-MMM-YYYY') as MonthEnd
In FrontEnd use
But the month end does not give any data.
And the main query is I have date field and I want to calculate Last Quarter Exit.
If I select Aug then date should appear as 30-June-2017.
And from date field I am able to calculate Last Quarter month by using :
But not getting last date of this month.
Refer sample apps posted in Can we put condition in max function
I guess you will get desired result from that link