2 Replies Latest reply: Sep 6, 2015 3:42 AM by Yeo Poh sai RSS

    How to change my YearMonth script start to Dual ?

    Yeo Poh sai

      Hi All


      I have a Load Script as below :-


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

      as YearMonth,


      I like to change the above using Dual , meaning some thing like :-


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


      As i encounter issue when i use YearMonth field in QS . it display as number instead of YearMonth like 2015 Jan.