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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Unable to get the Proper Date Format for Overtime Period Start & END DATE for US Payslip

in Payroll and Global Payroll Interface (GPI) 3 comments

Summary:

Unable to get the Proper Date Format for Overtime Period Start Date & Overtime Period End Date in Oracle Delivered US Pay Slip(BIP - RTF Template).

Overtime Rate Calculation Information Section. Below are the Fields
Start Date: OVERTIME_PERIOD_START_DATE
End Date: OVERTIME_PERIOD_END_DATE

Currently we are getting the Date Format as DD-MM-YYYY, and we need to convert it to MM/DD/YYYY. We tried multiple conditions Like Date_Format/TO_CHAR/TO_DATE etc., and it doesn't work.


Below is the data from XML output, we need to convert it to MM/DD/YYYY.

<OVERTIME_PERIOD_START_DATE>15-09-2024</OVERTIME_PERIOD_START_DATE>

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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