Date issues

Question

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

V Khanna · Answer

We had the same version on Windows and applying the patch fixed the issue.

Regards,

User_MSQS7 · Answer

Hi

My OBIEE version is 11.1.1.7.151020 (Build 151014.0951 64-bit) , Can I apply below patch.

Patch Name

Description

Release

Platform (Language)

Recommended

Product

Classification

Updated

Size

Download Access

20801340OBIEE 11G : EXCEL 2007 DATES BEYOND 12/31/2099 (Patch)11.1.1.7.180417Microsoft Windows x64 (64-bit) (American English)Oracle Business Intelligence Enterprise Edition(More...)General13 days ago642.7 KBSoftware

Thanks!!

V Khanna · Answer

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

https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/2062971_1.htm…

Thank You.