Select two dynamic date ranges with a button

[felix18807]

Is there any way of getting a date range selected using a button for the filter below?

Basically I want to be able to dynamically select from April this year to today AND from April last year to 1 year ago today.

='(>=$(=yearstart(addyears(today(),-1),0,4)) ' &
'<$(=addyears(today(),-1))) AND ' &
'(>=$(=yearstart(today(),0,4)) ' &
'<$(=today()))'

Many Thanks

[MayilVahanan · Accepted solution]

HI

Try like this

='((>=$(=yearstart(today(),0,4)) ' & '<$(=today()))' & '*|*' &'(>=$(=yearstart(addyears(today(),-1),0,4)) ' &'<$(=addyears(today(),-1))))'

Hope it helps

[felix18807]

Ahh it was the | character that I was missing! TYVM