5 Replies Latest reply: Jan 24, 2014 6:10 PM by Srikanth P RSS

    Rolling Past 12 Months

    Dinesh Reddy Seelam

      Hello Every One

       

      The below statement working perfectly alright but does the past 12 months will be changing daily once the script is reloaded ?

       

         Let vMin = num(Makedate(2011,01,01));

         Let vMax = num(today());

       

         Temp:

          Load

            Date($(vMin) + Iterno() -1) as Date

          Autogenerate 1

          While Date($(vMin)) + Iterno() -1 <= $(vMax);

       

          MasterCal:

          Load Date,

          Month(Date) as month,

          Year(Date) as Year

          Resident Temp;

       

          Drop table Temp;