3 Replies Latest reply: Nov 21, 2014 7:33 AM by Yeo Poh sai RSS

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

    Yeo Poh sai

      Hi All



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




      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 ?