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

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

Date with time data changes after exporting to Excel from BI publisher report - using NON RTF method

Received Response
edited Oct 7, 2019 10:16PM in Oracle Analytics 6 comments


Time data changes after exporting to Excel from BI publisher report - not used rtf template


Hello everyone,

i have date data format in the database as 07-OCT-19 PM. (oracle database).  

created datamodel and report  based on above date field. properties set like 

formating mask: MM/dd/yyyy hh:mm:ss tt

formatting style: Microsoft

ignore user timezone: True.

once i set above properties, in the report editor the date value displaying correctly as 10/07/2019 12:22:29 PM

Whereas once i generate the report and view in the excel output its displaying time as 10/07/2019 06:22:29 PM

why this time is changing? how to avoid this issue? please help me on this really appreciate it.

Howdy, Stranger!

Log In

To view full details, sign in.


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