Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Issue with the date comparison for qlikview incremental load

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

2 Replies
Creator II
Creator II

Hi,

 

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

 

Thanks

Highlighted
Digital Support
Digital Support

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

https://community.qlik.com/t5/New-to-QlikView/Loading-Date-from-Oracle-DB-to-QlikView/m-p/2737

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.