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