My Oracle Support Banner

Increase one day when you export the data of 2100 and later in Excel 2007 (Doc ID 2060913.1)

Last updated on APRIL 14, 2020

Applies to:

Business Intelligence Server Enterprise Edition - Version to [Release 11g]
Information in this document applies to any platform.


Exporting the data beyond date 12/31/2099 to Excel 2007, it shows the date increased by one day.

The issue can be reproduced using Sample Sales Lite:

  1. Create new analysis the below columns

TIMESTAMPADD(SQL_TSI_YEAR,90, "Time"."Calendar Date") 
Calculated Tacts.Actual Unit Price

  1. Show the analysis on BI

Brand   TIMESTAMPADD(SQL_TSI_YEAR,90,Calendar Date) Actual Unit Price
BizTech     2100/04/22                     80.71
HomeView 2098/06/13                     60.65
BizTech     2100/12/29                     60.62
BizTech     2100/06/22                     59.28
BizTech     2099/02/10                     15.04

  1. Export to 2007 Excel

Brand   TIMESTAMPADD(SQL_TSI_YEAR,90,Calendar Date) Actual Unit Price
BizTech     4/23/2100(*)                      80.71
HomeView 6/13/2098                         60.65
BizTech     12/30/2100(*)                     60.62
BizTech     6/23/2100(*)                        59.28
BizTech     2/10/2099                          15.04



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.