Date issues

User_MSQS7

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

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.

User_MSQS7

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

20801340

OBIEE 11G : EXCEL 2007 DATES BEYOND 12/31/2099 (Patch)

11.1.1.7.180417

Microsoft Windows x64 (64-bit) (American English)

Oracle Business Intelligence Enterprise Edition(More...)

General

13 days ago

642.7 KB

Software

Thanks!!

V Khanna

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

Regards,