Dates prior to January 1, 1583 are blank when imported through Information links
Article ID: KB0080860
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All Versions |
Description
If an Information link with a date column has dates before January 1, 1583, then those dates of year 1582 and earlier will be empty when imported into Spotfire (other dates after that time will display as expected). This results in the cells corresponding to those values being null.
For example, original data:
For example, original data:
1/1/2018 1/1/1580 1/1/1581 1/1/1582 1/1/1583 1/1/1584After importing via the JDBC based Informatoin LInk would result in:
1/1/2018 1/1/1583 1/1/1584
Issue/Introduction
A date column when imported through information link if has dates prior to January 1, 1583, the corresponding values in visualizations will be blank
Resolution
This is because the Java/JDBC function call being used to read dates, uses the Gregorian calendar which was introduced during the end of 1582. Hence this does not work for previous years.
As a work around, change the data type of the date column element to String in the Information Designer and once it is imported into Spotfire, you can create a calculated column and convert it back to date-time using the Date() or DateTime() functions. This way all the dates before January 1, 1583 will be visible.
As a work around, change the data type of the date column element to String in the Information Designer and once it is imported into Spotfire, you can create a calculated column and convert it back to date-time using the Date() or DateTime() functions. This way all the dates before January 1, 1583 will be visible.
Additional Information
Feedback
Yes
No
Powered by
