topic Re: SAP Connector (latest 6.xx) how to express date string in OpenSQL in QlikView https://community.qlik.com/t5/QlikView/SAP-Connector-latest-6-xx-how-to-express-date-string-in-OpenSQL/m-p/1286347#M1230767 <HTML><HEAD></HEAD><BODY><P>Hi Atsushi</P><P></P><P>Have you tried YYYYMMDD wrapped in single quotes eg. '20160106'</P></BODY></HTML> Fri, 06 Jan 2017 17:29:48 GMT cmsjamesgreen 2017-01-06T17:29:48Z SAP Connector (latest 6.xx) how to express date string in OpenSQL https://community.qlik.com/t5/QlikView/SAP-Connector-latest-6-xx-how-to-express-date-string-in-OpenSQL/m-p/1286346#M1230765 <HTML><HEAD></HEAD><BODY><P>Hi Gurus, would you possibly advise how I can express in SAP OpenSQL with any date variable? </P><P></P><P>For example, billing table VBRK has FKDAT (Invoice posting Date). </P><P>I would like to make such: </P><P></P><P>SELECT VBELN FKDAT FROM VBRK </P><P>WHERE FKDAT = <SPAN style="color: #575757; text-decoration: underline;"><STRONG>(date)</STRONG></SPAN></P><P></P><P>How would you set this date? I tried Date(2017-01-06), or like SAP, "06.01.2017" or 20170106, but all resulted in loading error. </P><P>Actually on SQL server, it is recorded as 20170106 as numeric. </P><P></P><P>ABAP resource at the client advised me that in ABAP code, it is always creating an ABAP variable before executing SQL, so it is not really known if it is possible to have date syntax within OpenSQL. </P><P></P><P>I should highly appreicate for your wisdom in advance. </P></BODY></HTML> Mon, 26 Jan 2026 21:26:37 GMT https://community.qlik.com/t5/QlikView/SAP-Connector-latest-6-xx-how-to-express-date-string-in-OpenSQL/m-p/1286346#M1230765 atsushi_saijo 2026-01-26T21:26:37Z Re: SAP Connector (latest 6.xx) how to express date string in OpenSQL https://community.qlik.com/t5/QlikView/SAP-Connector-latest-6-xx-how-to-express-date-string-in-OpenSQL/m-p/1286347#M1230767 <HTML><HEAD></HEAD><BODY><P>Hi Atsushi</P><P></P><P>Have you tried YYYYMMDD wrapped in single quotes eg. '20160106'</P></BODY></HTML> Fri, 06 Jan 2017 17:29:48 GMT https://community.qlik.com/t5/QlikView/SAP-Connector-latest-6-xx-how-to-express-date-string-in-OpenSQL/m-p/1286347#M1230767 cmsjamesgreen 2017-01-06T17:29:48Z