topic Year function on SAP SQL query in QlikView https://community.qlik.com/t5/QlikView/Year-function-on-SAP-SQL-query/m-p/1415375#M1230424 <HTML><HEAD></HEAD><BODY><P>Hi Qlikers,</P><P></P><P>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.</P><P>The question is: Is there a way to perform a function YEAR on SAP SQL Connector?</P><P>Somebody have tried something, instead a temptable to use on a second query with wildmatch.</P><P>We already tried the function YEAR(field) and the error message regarding "(" is been displayed.</P></BODY></HTML> Mon, 26 Jan 2026 21:26:37 GMT Ricardo_Gerhard 2026-01-26T21:26:37Z Year function on SAP SQL query https://community.qlik.com/t5/QlikView/Year-function-on-SAP-SQL-query/m-p/1415375#M1230424 <HTML><HEAD></HEAD><BODY><P>Hi Qlikers,</P><P></P><P>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.</P><P>The question is: Is there a way to perform a function YEAR on SAP SQL Connector?</P><P>Somebody have tried something, instead a temptable to use on a second query with wildmatch.</P><P>We already tried the function YEAR(field) and the error message regarding "(" is been displayed.</P></BODY></HTML> Mon, 26 Jan 2026 21:26:37 GMT https://community.qlik.com/t5/QlikView/Year-function-on-SAP-SQL-query/m-p/1415375#M1230424 Ricardo_Gerhard 2026-01-26T21:26:37Z