File Exports to Excel hold mixed US and European date formats (Doc ID 785485.1)

Last updated on DECEMBER 18, 2016

Applies to:

Siebel CRM - Version 7.7.2 [18325] and later
Information in this document applies to any platform.

Symptoms

The customer was using Siebel 7.8.2.10 and had found an issue when exporting rows via Menu > Export. The issue is shown when the .csv file is opened in Microsoft Excel whereby the date format is not homogenous. However, if the file is exported as a .txt file and opened in another application, like Textpad or Notepad, the dates appear to be homogenous. The same issue is seen across Siebel versions.

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