OBIEE Export to Excel 2007+

Question

Hi All,

when we are exporting the analysis in excel 2007+ the date fields in the reports are showing as text fields instead of date. even if we try to change it excel is not allowing us to change. when we apply filter on the date fields it is showing as below.

But we wanted to see them as below

This is working fine in 2003 but not in 2007+. The version we are using is 11.1.1.7.140415 . How to fix/ achieve this in 2007+

Please help me with suggestions.

Thanks !

3174977 · Answer

Sorry Gianni. Its the same question.. I thought since no one responded to my earlier post created a new thread with the same post.. Sorry.. Actually this requirement is very urgent and I am looking for some suggestions.,

Thanks !

Gianni Ceresa · Answer

Hi,

How is this thread different than what you posted in When the OBIEE report is exported to Excel 2007 date columns are saved as text instead of date ?

Don't double post and don't start multiple threads for the same things as the result is in general less answers and more unclosed threads in the forum...