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:




      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