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



      Can anyone help me?