We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

OTBI Edit Column Formula for YYYYMMDD

Accepted answer
11
Views
7
Comments

Summary:

Hello, We tried using the solution listed in the Oracle Doc below but unable to successfully edit the column formula of the OTBI analysis for Workforce Management - Worker Assignment Real Time SA | Worker Folder | Date of Birth and Enterprise Hire Date so that the format shows as YYYYMMDD. This is ncessary as this analysis is the basis for a data model and BIP Report.

Oracle Fusion BIP: How to change the date Format in OTBI analysis so that it keeps the formatting in BI Publisher Reporting. (Doc ID 2184776.1)

Solution: CASE WHEN "Worker"."Employee Hire Date" is not null THEN CONCAT (CONCAT( CONCAT( CONCAT(SUBSTRING((CAST("Worker"."Employee Hire Date" AS CHAR)) FROM 9 FOR 2), '/') , SUBSTRING((CAST("Worker"."Employee Hire Date" AS CHAR)) FROM 6 FOR 2)), '/'), SUBSTRING((CAST("Worker"."Employee Hire Date" AS CHAR)) FROM 1 FOR 4)) ELSE '' END

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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