I am sure I am getting the syntax wrong. I am trying to format my dates from 2012-12-01 to Dec 2011
When I try: Format([MonthYr],'MM-yyyy') as MonthYr,
Msg 195, Level 15, State 10, Line 2
'Format' is not a recognized built-in function name.
What am I doing wrong?