Use button to select 2 values in a list

[fgirardin]

Hello everyone,

I'm trying to create a button that would select the current and previous year in a list

YEAR field contains years in YYYY format from 2008 to 2017

Here is the list using my field "ANNEE"

If I use an action to select data in this field, I can select both year using

(2016|2017)

However this is means that I need to change it each year

I can select current year in my field using

=(Year(max(Date)))

But I can't find a way to select both current and previous year...

Is it possible ?

Thank you for your help

FG

[adamdavi3s]

You need a select in field, then a toggle select in field

=(Year(max(Date)))

=(Year(max(Date)))-1

[adamdavi3s · Accepted solution]

Please see the attached example

[fgirardin]

Hello Adam,

Thank you ! I was struggling to find a way and the solution was in front of my eyes the whole time XD

Have a nice day !

FG