Qlik Community

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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
0 Replies