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