3 Replies Latest reply: May 9, 2012 4:13 AM by Ionut Biliuti RSS

    Month Year format

    Ionut Biliuti



      To display in order Month and Year I use this expresion:

      dual( Month(MyDate) & '-' & Year(MyDate), num(Year(MyDate)) & num(Month(MyDate), '00' )) as MonthYear,


      and the result is something like MMM-YYYY.

      How should I change the expression
      or what else should I do to change the format display in something like that MMM-YY ?


      Thanks for help,