Exports to Excel Show Mixed 12-Hour and 24-Hour Date Formats
Last updated on DECEMBER 15, 2016
Applies to:Siebel Financial Services CRM - Version 126.96.36.199 SIA and later
Information in this document applies to any platform.
**checked for relevance on 15-DEC-2016**
On : 188.8.131.52 SIA version, Client Functionality
Siebel: File Exports to Excel hold mixed 12 and 24 date formats
The file exports to Microsoft Excel from Service Request List Applet show mixed 12 and 24-hour formats.
The application language is Spanish and the time zone in user preference is set to GMT-5: (Bogota LImo Quito).
The format data should stay with same format when exported
With the Server and User in different Regional Time Zone settings
The issue can be reproduced at will with the following steps:
1. export the service request list with default settings
2. save the file.
3. the Excel file. You can see Created date column
5.The created date column display data in different format
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms