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 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.

Symptoms

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

(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.



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