Month + year concatenation mmm-yy

[infock12]

Hi all,

I have a date field and would like to get in month year format. I tried the below. I have the attendance date stored as '2016-07-12 00:00:00.000' and I would like it to show 'mmm-yy'

Month(Attendance_Date) & '-' & Year(Attendance_Date) as 'MonthYear'

but I get load error. I tried other things too by looking at other comments but i still get the same error. Any help is appreciated.

Thanks

[infock12]

Hi Anil,

Sorry for the late response. It does work and I have marked it as a correct answer.

Many thanks,

Karthik