3 Replies Latest reply: Nov 14, 2012 8:39 AM by Jonathan Dienst RSS

    change the format of a date

      Hi, i have a date field in the format of    DD/MM/YYYY

      I am trying to seperate it in the script for day, month, year which i have done by :

       

      Day(Date_Field) as Day,

       

      Month(Date_Field) as Month,

       

      Year(Date_Field) as Year,

       

      But i also want a field for Month-Year but i only want the last 2 digits of the year displayed

       

      so i want..

       

      Jan - 12

      Feb - 12

      ect.

       

      Can anyone help me?