My Oracle Support Banner

E-QR: Different Query Results For Date Fields in Excel Output (Doc ID 2121355.1)

Last updated on SEPTEMBER 03, 2021

Applies to:

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

Symptoms

After an upgrade to PeopleTools 8.54, 8.55, or 8.56, when running a Query to Excel output, the dates appear one date off from how they appear on either the web or the database.

For example, 1/1/1965 in Web output will appear as 12/31/1964 in the Excel output.

Changes

 

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
Changes
Cause
Solution
 A) Correct discrepancies between timezone settings
 B) Ensure that PeopleSoft timezone tables contain the necessary data
 Workaround
References


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