Business Analyticspublic

Business Intelligence

Get Involved. Join the Conversation.

This is a public Forum  publicRSS

Topic

    Srekan
    Date with time data changes after exporting to Excel from BI...
    Topic posted October 7, 2019 by Srekan Red Ribbon: 250+ Points, last edited October 7, 2019, tagged BI Publisher, Business Intelligence 
    43 Views, 6 Comments
    Title:
    Date with time data changes after exporting to Excel from BI publisher report - using NON RTF method
    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.

    P.S. i am not using rtf template method design. in 11g getting properly values wheras in 12c getting issue.

    Regards,

    Joe

    Comment

     

     

    community forum