OBIEE 184.108.40.206 - Exported Excel Reports Are Showing Dates One Day Earlier Than What is Displayed in Answers
(Doc ID 2428290.1)
Last updated on SEPTEMBER 02, 2020
Applies to:Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.0 and later
Oracle Exalytics Software - Version 18.104.22.168.0 and later
Business Intelligence Answers Option - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Exported excel reports are showing dates one day earlier than what is displayed in answers
For example, Selecting 'Greater Than Or Equal To' for the filter with a date of 6/1/2017 for results in the following:
OBIEE report starts with 6/1/2017:
Export to Excel 2007+ report starts with 5/31/2017:
The issue can be reproduced at will with the following steps using sample sales rpd:
1. Select Calendar date.
2. Filter using 'Greater than or equal to'.
3. Select a date, such as 6/1/2017.
4. Results tab shows first cell of 6/1/2017.
5. Export to Excel 2007+ and see the first cell of 5/31/2017.
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