I've got an issue where I want to load date from MS Access to QlikView but there seems to be this error coming up.
Error : SQL##f - SqlState: S1000, ErrorCode: 1843, ErrorMsg: [Oracle][ODBC][Ora]ORA-01843: not a valid month
The date that i'm loading from MS-Access is this format .
The Query that I've Written on QlikView in order to get the data only for that particular day.
But the error i've been facing is not understandable to me as I'm new to QlikView.
Any sort of help is appreciated.
Thanks in advance.
if you have Oracle,
you can use an Oracle function to convert a string to a date
where oracledatefield >= to_date('20012018 05:00:00', 'DDMMYYYY HH24:MI:SS')
or if you only need a date
where oracledatefield >= to_date('20012018', 'DDMMYYYY')
Within "Date Field" = '1201/2017' is a typo and it should be "Date Field" = '12/01/2017'. Further I'm not sure if access accept the single-quotes or if it must be another quoting maybe with double-quotes like: "Date Field" = "12/01/2017".
use another provider?
OLEDB CONNECT32 TO [Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=Z:\Spec.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=4;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False];
I wasn't sure until my Lead confirmed it to me.
Its from ORACLE To QLIKVIEW.
I tried the above but its not working out.
So what I did based on a small condition I pulled out some data from the ORACLE DB to have a look at the format of the "DATE_FIELD".
So this is the date field that I have in my ORACLE DB,
But i'm just not sure how do I pull it into QLIK.
The query which I tried but hasn't worked out.
Also , I'll correct the Discussion Topic.