Exports to Excel Show Mixed 12-Hour and 24-Hour Date Formats
(Doc ID 2005466.1)
Last updated on DECEMBER 15, 2016
Applies to:Siebel Financial Services CRM - Version 220.127.116.11 SIA and later
Information in this document applies to any platform.
**checked for relevance on 15-DEC-2016**
On : 18.104.22.168 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!