My Oracle Support Banner

E1: GRID: Incorrect Date Format in Excel Data for JDE Utime Fields with ActiveX Off (Doc ID 2449532.1)

Last updated on FEBRUARY 04, 2019

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 to 9.2 [Release 9.2]
Information in this document applies to any platform.

Symptoms

With activeX is set to False:  Grid shows data in DDMMYY format for JDE Utime fields correctly but when exported to excel, excel data is in MMDDYY format. User profile date format is set to DMY to have the date format in DDMMYY format.

It is the same issue for export to excel from databrowser as well.

Same issue happens in non-IE browsers with activeX set to True as non-IE browsers do not  use activeX controls even if it is set to true in jas.ini

Grid data in DDMMYY format:



Excel data in MMDDYY format:

 

Cause

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
Symptoms
Cause
Solution
References


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