3 Replies Latest reply: Nov 21, 2014 7:33 AM by PAUL YEO RSS

    master calendar only row 1 have year month the rest missing value

    PAUL YEO

      Hi All

       

       

      I have create a master calendar using the below script :-

       

       

      MasterCalendar:

      LOAD TempDate AS date_time,

       

       

          Date(Monthstart([TempDate]), 'YY MMM')                          as YearMonth,

        MY AS MonthYear,

          D     AS Day,

          M     AS Month,

        Y AS year

      RESIDENT TempCalendar

      ORDER BY TempDate ASC;

       

       

      DROP TABLE TempCalendar;

       

       

       

       

      My issue is YearMonth field does not recode the date_time only the first row , and give the rest of the row missing value , where i make the mistake ?

       

       

      Paul