Direct links to fixes
APAR status
Closed as fixed if next.
Error description
1. Create user with a Arizona timezone and the AppServer/Db server is on CST timezone. 2. Created Building record with "In Service Date of 1/13/2017" current time was 11:40am. 3 Create a Query of building with columns name and in service date The values from the query are ok but when you export it to Excel the date on the export of "In Service Date reflects a day before (1/12/2017).
Local fix
No
Problem summary
The issue was that export Excel was not correctly using the system time zone when handling Date fields.
Problem conclusion
Date fields are no longer showing incorrect results when the TRIRIGA user exporting the Excel is configured with a different time zone than the time zone of the TRIRIGA AppServer. This is targeted to the 1h2017 release.
Temporary fix
Comments
APAR Information
APAR number
IV93085
Reported component name
TRI APP PLTFM R
Reported component ID
5725F26RE
Reported release
351
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-02-03
Closed date
2017-02-13
Last modified date
2017-02-13
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
999
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHEB3","label":"IBM TRIRIGA Application Platform"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"351","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
30 March 2022