My Oracle Support Banner

E1: GRID: Date Column Exports with Wrong Year Century When Exporting To Excel (Doc ID 1281607.1)

Last updated on NOVEMBER 22, 2019

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.


When we extract data from an EnterpriseOne application to Excel using the Export method, we are having problems with the date representation. For example, the date 31/12/40 is appearing as 31/12/1940 in Excel.  What is the cause and how can this be corrected?


To view full details, 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 a vibrant support community of peers and Oracle experts.