Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI
Try like this
='((>=$(=yearstart(today(),0,4)) ' & '<$(=today()))' & '*|*' &'(>=$(=yearstart(addyears(today(),-1),0,4)) ' &'<$(=addyears(today(),-1))))'
Hope it helps
HI
Try like this
='((>=$(=yearstart(today(),0,4)) ' & '<$(=today()))' & '*|*' &'(>=$(=yearstart(addyears(today(),-1),0,4)) ' &'<$(=addyears(today(),-1))))'
Hope it helps
Ahh it was the | character that I was missing! TYVM