E-QR: Date Format In Windows Query In Excel Is Different From Date Format In Query Manager
Last updated on JANUARY 03, 2017
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.
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