My Oracle Support Banner

Contact Export From Menu->Export Gives Wrong Date Format For Created Field (Doc ID 2146124.1)

Last updated on NOVEMBER 22, 2019

Applies to:

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


ISSUE: Export Functionality gives wrong date format in excel. It looks fine on UI and same in Database. But after exported in excel, it shows two different format Created Field. One is "General" and other is "Custom" which is the wrong one.

When users convert Created column in excel to Date(Short or Long) format, custom format reverse month and date. For example,
There are two formats:
12/05/2016 12:02:30 ----General
12/5/2016 12:2:3 ---Custom

And it will convert to
12 May 2016---long Date
5 Dec 2016---long date

QUESTION: Why do the dates set up wrong?



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.