3 Replies Latest reply: Feb 27, 2017 11:35 AM by Aar Kay RSS

    what is wrong with the resident load?

    Maria Harmening

      Greetings,

       

      I have a fact table called AllData that I load.  then I'm trying to loop through the next 12 months to populate a MonthData table.  however, there's something wrong with my statement.  what am I doing wrong?

       

      ...

      MonthName(addmonths(today(),IterNo())) as MonthYear

      Resident AllData

      While MonthName(addmonths(today(),IterNo())) <= $(vEndDate);

       

      I define vEndDate at the beginning of the script using MonthName(addmonths(today(), 12)).  it's Feb 2018.