2 Replies Latest reply: Sep 6, 2015 3:42 AM by PAUL YEO RSS

    How to change my YearMonth script start to Dual ?

    PAUL YEO

      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.

       

      Paul