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