10 Replies Latest reply: May 19, 2017 1:54 PM by Jacob Salas RSS

    Date Range Selection Compare Previous Year

    Jacob Salas

      I hope there is an easy solution for this.  But i'm having trouble creating a variable that computes the previous years selection.

       

       

      Selection:

      SHIFT_DATE >=01/30/2017 <=05/28/2017

       

      I want a variable for the following:

      vMaxCompareDate = 05/28/2016

      vMinCompareDate = 01/30/2016

       

      My goal is to create a trend per day of previous years selection without going back and forth between selections.