Qlik Community

QlikView Connector for SAP

Discussion Board for collaboration related to the QlikView Connector for SAP.


Year function on SAP SQL query

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.

Community Browser