Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The database I'm loading from has a few dates that get set to 01/01/10000. Yes, the year 10,000!
Oracle will create a date field with this date, but when I try to load it into Qlikview I get
ErrorMsg: [Oracle][ODBC]Invalid datetime format
Is this a limitation of Qlikview or is there some setting that would circumvent the error?
Thanks
I don't think that's related to Qlik because if you used: = makedate(10000) within a textbox it showed just the 01/01/10000. I assume that your used driver couldn't handle it - maybe you could try another one.
- Marcus
I don't think that's related to Qlik because if you used: = makedate(10000) within a textbox it showed just the 01/01/10000. I assume that your used driver couldn't handle it - maybe you could try another one.
- Marcus
What is your source DBMS? And the original data type?
As far as I know, Oracle date data type range is limited to year 9999:
Good thought on ODBC driver. Can't find any confirmation, but it sounds likely.
The Oracle field is a DATE datatype. I did a little research and found that you could store dates past 9999 in an Oracle date field because of the size. Found this as a reference:
Will continue to look into the ODBC driver. I think the solution is to not have such a crazy date in the source DB!