Display Maximum or most Recent Years on the List Box Properties

[Anonymous]

Good Morning..

I am facing one issue where i have list of Years  from 2000 to 2015  in List Box Properties and I wanted to display only maximum or recent 3 years on in List Box.Can anybody help me to resolve this issue.Thank You !

[rubenmarin]

Hi Prasad, to show the recent 3 years in a list box you can use:

=Aggr(Only({1<YearField={'>$(=Year(Today())-3)'}>} YearField), YearField)

[Anonymous]

Thank You Ruben .It works for me.:)