Date with time data changes after exporting to Excel from BI publisher report - using NON RTF method
SummaryTime data changes after exporting to Excel from BI publisher report - not used rtf template
i have date data format in the database as 07-OCT-19 126.96.36.1994000000 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.