ODBC Date Conversion

SUGGESTED

Hi All,

Hopefully someone has dealt with this issue before

ODBC links are set up and usually work fine as lone as I don't use anything beyond SELECT, FROM, WHERE, AND, GROUP BY and ORDER BY

However, I want to convert a date field to "MM-YY" for a project I am working on, and no matter what I try I get an error saying "column not found" (cast,convert,format etc etc)

Does anyone have any tips?

Thanks and regards,

Josh