4 Replies Latest reply: Nov 24, 2011 8:09 AM by diesirae33 RSS

    24 rolling months from last date

      How can I get my calendar to display 24 rolling months from the last date in my table of dates? Here's the code for the start end endpoints:

       

      tmp:

      LOAD

      min(OrderDate) as MinDate,

      max(OrderDate) as MaxDate

      RESIDENT Orders;

      LET Start = floor(YearStart(peek('MinDate')));

      LET End = floor(???);

      Drop Table tmp;

       

      Grateful for any help!

       

      // John