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());




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

          Autogenerate 1

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



          Load Date,

          Month(Date) as month,

          Year(Date) as Year

          Resident Temp;


          Drop table Temp;