2 Replies Latest reply: Nov 7, 2012 3:42 AM by Richard Beeston RSS

    Select two dynamic date ranges with a button

      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)) ' &

      Many Thanks