Qlik Community

Ask a Question

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Ricardo_Gerhard
Employee
Employee

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
LATAM
0 Replies