Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
I need help to correct a Data Extract - eText - Timezone Issue — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

I need help to correct a Data Extract - eText - Timezone Issue

Incorrect Answer
3
Views
1
Comments

Summary:

I have a data extract and the output uses an eText file for the data layout. That attached document shows a snippet of the eText where FORMAT_DATE(SYSDATE,'MM/DD/YYYY') is being used.

The document also shows our discovery of the date issue is causing to a downstream application from HCM. The file generated at 5:47 PM EST has the date shown as 12/5/2022. However, the same data extract that was generated at 8:48 PM EST shows a date of 12/6/2022. This is due to ETC not being -5 hours from UTC and normally EST is -4 hours from UTC.

What date am i to use that no matter the time from 00:00 to 23:59 on 12/5/2022 EST that the system date or whatever is 12/5/2022?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!