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)) ' &
      '<$(=today()))'

      Many Thanks