2 Replies Latest reply: Mar 15, 2011 2:24 AM by Nicolas ALLANO RSS

    Script distinct date + append 12 coming month


      I want to retrieve all distinct dates (all in format MMM YYYY, using MonthName function) from my fact table and then append them by the next coming 12 months, here is my script but it is not working. Any suggestion

      Load Distinct OpenMonth as newDate
      Resident Fact;
      CONCATENATE (tmp)
      MonthName(Max(OpenMonth),IterNo()) as newDate
      RESIDENT Fact
      while MonthName(Max(OpenMonth),IterNo()) <= MonthName(Today(),12)