OTBI Report Date Format changes when exporting to Excel
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:
0