topic Re: ODBC READ FAILED in QlikView https://community.qlik.com/t5/QlikView/ODBC-READ-FAILED/m-p/916084#M651746 <HTML><HEAD></HEAD><BODY><P>I think your database is expecting a date time.. try using DT() function</P></BODY></HTML> Mon, 27 Jul 2015 14:10:51 GMT sasiparupudi1 2015-07-27T14:10:51Z ODBC READ FAILED https://community.qlik.com/t5/QlikView/ODBC-READ-FAILED/m-p/916081#M651743 <HTML><HEAD></HEAD><BODY><P>Hi I m getting this error because of this message QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: 22007, ErrorCode: 4294967116, ErrorMsg: [IBM][CLI Driver][DB2/LINUXX8664] SQL0180N&nbsp; The syntax of the string representation of a datetime value is incorrect.&nbsp; SQLSTATE=22007 my load script : load "a",&nbsp;&nbsp;&nbsp; "b",&nbsp; "date",&nbsp;&nbsp;&nbsp; "DESIGNATION"; SQL SELECT * FROM "db.tableemp" where DATE(date)&gt;=DATE('$(vLast27months)'); and where let vLast27months=date(Monthstart(today(),-9*3),'YYYYMMDD'); I m extracting the data using this where condition . Please help me out !!</P><P></P><P>Message was edited by: Deepak Kumar</P></BODY></HTML> Mon, 27 Jul 2015 13:47:05 GMT https://community.qlik.com/t5/QlikView/ODBC-READ-FAILED/m-p/916081#M651743 2015-07-27T13:47:05Z Re: ODBC READ FAILED https://community.qlik.com/t5/QlikView/ODBC-READ-FAILED/m-p/916082#M651744 <HTML><HEAD></HEAD><BODY><P>you can not mix qlikview functions with sql..</P></BODY></HTML> Mon, 27 Jul 2015 13:57:20 GMT https://community.qlik.com/t5/QlikView/ODBC-READ-FAILED/m-p/916082#M651744 sasiparupudi1 2015-07-27T13:57:20Z Re: ODBC READ FAILED https://community.qlik.com/t5/QlikView/ODBC-READ-FAILED/m-p/916083#M651745 <HTML><HEAD></HEAD><BODY><P>Can you send your script again, with break lines? I believe the problem is you using DATE, the Qlikview function, on a SQL script, but I'm not sure because the code is confusing without properly indentation...</P><P></P><P>-- Lucas</P></BODY></HTML> Mon, 27 Jul 2015 14:01:40 GMT https://community.qlik.com/t5/QlikView/ODBC-READ-FAILED/m-p/916083#M651745 Anonymous 2015-07-27T14:01:40Z Re: ODBC READ FAILED https://community.qlik.com/t5/QlikView/ODBC-READ-FAILED/m-p/916084#M651746 <HTML><HEAD></HEAD><BODY><P>I think your database is expecting a date time.. try using DT() function</P></BODY></HTML> Mon, 27 Jul 2015 14:10:51 GMT https://community.qlik.com/t5/QlikView/ODBC-READ-FAILED/m-p/916084#M651746 sasiparupudi1 2015-07-27T14:10:51Z