3 Replies Latest reply: Mar 19, 2015 1:11 PM by Richard Pearce RSS

    Dates in a variables - how to set a date

    sarah worthy

      I have a set analysis in a variable which restricts the X Axis from showing all the Week Endings

      i.e. vWKENDMAX showing the last point on the x axis

       

      =

       

      date(max([Week Ending])-21) 

       

       

       

      I now need the x axis to start at a specific point.  The activity in the graph start at specific point so for instance it would let me specify

       

      vWKEND as

       

      =01/01/2014 in the variable.

       

       

      but because I have a rolling date range in my loading script I want the start point on the X axis to start either on this date or if the rolling range passes this point I want it to  read something like this:

      =date(Min([Week Ending])+21) 

       

      How would l write this please?

      I tried an IF statement in my vWKEND but it didn't seem to work.

       

      Please advise

      Thank you