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

Last updated on MAY 30, 2017

Applies to:

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

Symptoms

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?

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