Dates prior to January 1, 1583 are blank when imported through Information links

Dates prior to January 1, 1583 are blank when imported through Information links

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:

1/1/2018
1/1/1580
1/1/1581
1/1/1582
1/1/1583
1/1/1584

After importing via the JDBC based Informatoin LInk would result in:

1/1/2018 
 
 
 
1/1/1583 
1/1/1584

  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.
  Doc: Date and Time Functions:

• https://docs.tibco.com/pub/sfire-analyst/7.11.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/ncfe/ncfe_date_and_time_functions.htm