This content has been marked as final. Show 3 replies
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?