Year function on SAP SQL query

[Ricardo_Gerhard]

Hi Qlikers,

We want to recover some informations using SAP SQL Connector. There´s a datetime field on SAP environment to perfom a query on the specific interval.

The question is: Is there a way to perform a function YEAR on SAP SQL Connector?

Somebody have tried something, instead a temptable to use on a second query with wildmatch.

We already tried the function YEAR(field) and the error message regarding "(" is been displayed.