Error message with the Format Function

4

Just use the old method:-

select left(datename(month,su.updatedate),3) + '-' + convert(varchar(4),right(year(su.updatedate),2)) as  Audit_Month
FROM Sales.Update su