Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Date Format Not Exporting in Excel 2007+ — 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

Date Format Not Exporting in Excel 2007+

Received Response
69
Views
12
Comments
edited Aug 20, 2015 4:53PM in Reporting and Analytics Taleo Enterprise 12 comments

Summary

Even with override, date fields turning general columns in Excel 2010

Content

I'm having an issue with date formats in OBI.  Essentially, no matter what format we use on the query/analysis end, the date is changed to a text field in Excel and doesn't allow us to alter formats for filtering or pivot tables.  These are indeed date fields (Application Date, Hired Date, etc) and I've tried the original date version, overrides for other version and custom versions, nothing seems to work when exporting to Excel 2007+.  We have dozens or reports that go out to many users and we need to be able to use those as dates.  Some users pivot off the

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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