My Oracle Support Banner

OBIEE - 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 and later
Oracle Exalytics Software - Version and later
Business Intelligence Answers Option - Version 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

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