Hi all,

I have a report contains a field in date format

Example : 21 / 08 / 2007

I would like convert it to "mmm/yyyy"

I use the code in edit formula like this

Code:
    MonthName(Month({Table.Date1}),True) & " / " & year({Table.Date1})
However, my return format is : Aug / 2007.00
How can i make it return format = Aug / 2007


Your help is much appreciated. Thanks you