Discussion Board for collaboration regarding Qlik Connectors.
While comparing dates, a below-mentioned error has occurred in QV.
Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 1843, ErrorMsg: [Oracle][ODBC][Ora]ORA-01843: not a valid month
It seems that the date format in the backend database is not matching with the date format in qlik.
Below is the code for your reference,
MaxID1:LOAD Max(INSERTED_DATE)-1 as INSERTED_DATEResident V_QV_D_SALES_CASE;
Let vMaxDate= peek('INSERTED_DATE',0,MaxID1);
SQL SELECT * FROM SALES."V_QV_D_SALES_CASE"
Where "INSERTED_DATE">= '$(vMaxDate)';
Thanks in advance.