0 Replies Latest reply: Nov 17, 2017 12:19 PM by Ricardo Gerhard RSS

    Year function on SAP SQL query

    Ricardo Gerhard

      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.