Qlik Community

QlikView Connectors

Discussion board for collaboration related to QlikView Connectors.

Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
Showing results for 
Search instead for 
Did you mean: 

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.

Ricardo Gerhard
OEM Solution Architect