[CLOSE][CR 8.5]How convert data format to YYYY only
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:
'VB' 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;)
Re: [CR 8.5]How convert data format to YYYY only
Sorry for double thread, please help me to close thread.
thanks you