Extracting Date and DateTime from SAS Date Formats "yymmdd10"

Issue Description:

One of the SAS Date format Data Type is unable to read by Spotfire  "yymmdd10" which is ISO Standard. The retrieved data is irrelevant. For instance 21600 is equivalent to 2019-02-20 in SAS.

Cause:

SAS uses 1960-01-01 as the reference date for the way it stores dates. 

The following TERR (or R) command confirms that 21600 is the number of days between 1960-01-01 and 2019-02-20:
 > 
> 
> diff(as.POSIXct(c("1960-01-01", "2019-02-20"))) 
Time difference of 21600 days 
> 
 So this appears to be a data type conversion issue within the SAS OLEDB Providers.

Solution:

 You can bring the data to Spotfire and Create a Calculated column to extract the Date and DateTime.

Calculated Column for Date:
Date -- DateAdd('day',[Date of First Exposure to Treatment],Date('1960-01-01'))
DateTime -- DateAdd('ss',[Datetime of First Exposure to Treatment],DateTime('01/01/1960 12:00:00 AM'))

Example Data:

Attached the Sample Dashboard for reference.