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 8.2.2.2 SIA[23016] and later
Information in this document applies to any platform.
**checked for relevance on 15-DEC-2016**

Symptoms

On : 8.2.2.2 SIA[23016] 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



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms