topic Issue with the date comparison for qlikview incremental load in QlikView

Issue with the date comparison for qlikview incremental load

kishorj1982 — Sat, 16 Nov 2024 19:04:52 GMT

Hi All,

We are applying an incremental load. Whenever we are trying to compare dates we are getting an error like,

ODBC error

Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 1843, ErrorMsg: [Oracle][ODBC][Ora]ORA-01843: not a valid month

I have attached the sample file for your reference.

I am not getting how to go ahead with the comparison for dates.

Please suggest.

Thanks in advance.

Thanks

kishorj1982 — Fri, 21 Feb 2020 02:35:34 GMT

Hi,

Could you please assist me with this. I am not getting how to compare dates because of the current issue.

Thanks

Brett_Bleess — Wed, 25 Mar 2020 18:54:55 GMT

I believe you find some further information on the following prior Community post:

Regards,
Brett