5 Replies Latest reply: Dec 7, 2015 3:07 AM by Saumya Shah RSS

    Month Year Format

    Kumar Pramod

      Hi all,

       

      I am using below load script,

       

      Month(weekend(CanonicalDate)) as MonthPeriod,

       

      This will print only the month name as 'NOV'

      But i need like Nov-15.

       

      So i used

      Month(weekend(CanonicalDate)) & '-' & Year(CanonicalDate,'YY') as MonthPeriod

       

      But not working.

      Help on this.

       

       

      Regards,

      Kumar