Dates prior to January 1, 1583 are blank when imported through Information links
book
Article ID: KB0080860
calendar_today
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.
After importing via the JDBC based Informatoin LInk would result in:
1/1/2018
1/1/1583
1/1/1584
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.
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