MS Access Equivalent for T-SQL query

Question

I have a query some thing like this :

convert(varchar(7), [DateDelivered], 120) As Month_Delivered 

This does not seem to work with Access ODBC linked tables. what would be the equivalent for above ?

I have tried with CSTR , does not seem to work . I am getting error like :

Syntax error: missing operator in query expression .

Any thoughts on this ?

Answer 1

As DateDelivered is date, you would use Format in this case:

Format([DateDelivered], "yyyy-mm") As Month_Delivered