E1: GRID: Date Column Exports with Wrong Year Century When Exporting To Excel

(Doc ID 1281607.1)

Last updated on NOVEMBER 01, 2017

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?


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