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

    Month Year format

    Ionut Biliuti

      Hi,

       

      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,

      Ionut