Select Multiple years with On Open Trigger

[Brip51]

Hi,

I have a field with multiple years.  I have a On Open trigger that is currently hardcoded with the values (using

(2010|2011|2012|2013|2014|2015|2016|2017|2018|2019|2020) in the search string).

I cannot hardcode the values so I am trying to create a trigger based on the current year that will select ten years back. It seems like it should be easy, but I can’t get it to work.

If I use this

  ='<=2020' It works fine. Then I try :

='<=Year(Today())'

With that expression no years are selected.

=Year(Today()) works.

So I am guessing my syntax for less than is wrong??   I have tried different syntax, but I am spinning my wheels. 

Any help on this would be appreciated.

Thanks,

Brian

[edwin]

use something like 

='(' & concat(distinct {<YEAR={">=$(=max({1}YEAR)-10)<=$(=max({1}YEAR))"}>}YEAR, '|') & ')'

[MayilVahanan]

HI @Brip51 

Try like below