Show only the dates till we have data for table in slider

[udaya_kumar]

Hi,

I have a field name by name "Month_Name" which has value in database like jan2005,feb2005,..... till dec2020.

but we have currently data till feb2012, so i need to show the values in slider from jan2005.... feb2012.

but it is showing till dec2020. but if we get data for 2013, then the slider should show till 2013.

so how to do this?

i have written a macro which gets date from database till feb2012.

[udaya_kumar · Accepted solution]

Hi Experts,

i got the answer for this problem

i used below expression in slider

=aggr(only({<MONTH_START_DATE= P(MONTH_START_DATE)>}MONTH_START_DATE),MONTH_START_DATE)