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 with time data changes after exporting to Excel from BI publisher report - using NON RTF method — 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 with time data changes after exporting to Excel from BI publisher report - using NON RTF method

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

Summary

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

Content

Hello everyone,

i have date data format in the database as 07-OCT-19 12.22.29.994000000 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.

Register

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