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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Date Format Not Exporting in Excel 2007+

Received Response
69
Views
12
Comments
edited Dec 13, 2022 7:00AM in 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!