Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Date issues
Hi
I have a report When export in to excel 2207 its showing values are wrong, the export via Excel 2007 => All dates on or prior to 1969-12-31 are set to 1969-12-31, Could you please let me know about this issue
Colum : date column, report is fine when you export then only problem.
Thanks in Advance
Answers
-
Which version of OBI are you using ? This could be due to the below bugs if you are in 11.1.1.7.
Bug 20801340 - OBIEE 11G : EXCEL 2007 DATES BEYOND 12/31/2099
Bug 20912569 - DATES BEYOND 12/31/2099 ARE SHOWN WRONG WHEN EXPORTED TO EXCEL
Thank You.
0 -
Hi
My OBIEE version is 11.1.1.7.151020 (Build 151014.0951 64-bit) , Can I apply below patch.
Patch NameDescription
Release
Platform (Language)
Recommended
Product
Classification
Updated
Size
Download Access
20801340 OBIEE 11G : EXCEL 2007 DATES BEYOND 12/31/2099 (Patch) 11.1.1.7.180417 Microsoft Windows x64 (64-bit) (American English) Oracle Business Intelligence Enterprise Edition 
(More...)General 13 days ago 642.7 KB Software 0 -
We had the same version on Windows and applying the patch fixed the issue.
Regards,
0