Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
OTBI Report Date Format changes when exporting to Excel — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Report Date Format changes when exporting to Excel

21
Views
2
Comments
edited Sep 3, 2021 4:18AM in General Transactional Reporting (OTBI) 2 comments

Content

We are trying to change the formatting of a column in OTBI report by changing the column properties of each date columns. We are using the following format: 

Date Format: Custom

Custom Date Format: MM/dd/yyyy [TZ:(GMT-06:00) Central Time (US & Canada)]

Display Time Zone: Default

 

The dates are showing correctly in the results tab, but when exporting to excel, it loses the formatting, and becomes General format

Example:

Date when viewed on results tab: 03/01/2021 CDT

Date when exported to excel: 44348.10469

 

 

I read on this archived post that Oracle haven't rolled out yet a solution for this based on the last comment:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!