My Oracle Support Banner

E-QR: Date Format In Windows Query In Excel Is Different From Date Format In Query Manager (Doc ID 2009379.1)

Last updated on JANUARY 09, 2020

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 to 8.54 [Release 8.4]
Information in this document applies to any platform.


The date format is different in Windows Query vs. the date format in Query

(A) 2-3 Tier Query to Excel  => 2002-01-01
(B) PIA Query to Excel           => 1/1/2002

Client reported this bug in PT 8.53.12, but the behavior was also replicated in PT 8.54.05.


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.