Hi All,
While comparing dates, a below-mentioned error has occurred in QV.
ODBC error
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,
V_QV_D_SALES_CASE:
SQL SELECT
*
FROM SALES."V_QV_D_SALES_CASE";
MaxID1:
LOAD Max(INSERTED_DATE)-1 as INSERTED_DATE
Resident V_QV_D_SALES_CASE;
Let vMaxDate= peek('INSERTED_DATE',0,MaxID1);
V_QV_D_SALES_CASE:
SQL SELECT * FROM SALES."V_QV_D_SALES_CASE"
Where "INSERTED_DATE">= '$(vMaxDate)';
Please suggest.
Thanks in advance.
Thanks
