5 Replies Latest reply: Jan 23, 2016 7:18 PM by Jason Paul RSS

    Field Not Found...am I blind?

    Jason Paul

      Hello Everyone,

       

      First time poster here in the community.  I have the following script I'm trying to use, but I keep getting the Field Not Found error.  I can't seem to find the issue here, but it does appear to be in my MasterCalendar table.  Any help would be appreciated.

       

      LET vMinDate = NUM(MAKEDATE(1900,1,1));

      LET vMaxDate = NUM(MAKEDATE(2999,12,31));

       

      Temp:

      LOAD

      $(vMinDate) +  ITERNO() - 1 AS DateID,

      DATE($(vMindate) + ITERNO() - 1) AS TempDate

      AUTOGENERATE 1 WHILE $(vMinDate) + ITERNO() - 1 <= $(vMaxDate);

       

      MasterCalendar:

      LOAD

      TempDate,

      TempDate AS CalendarDate,

      WEEK(TempDate) AS Week,

      YEAR(TempDate) AS Year,

      MONTH(TempDate) AS Month,

      DAY(TempDate) AS Day,

      'Q' & CEIL(MONTH(TempDate)/3) AS Quarter

      RESIDENT Temp

      ORDER BY TempDate ASC;

       

      DROP TABLE Temp;