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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Formatting as date within string

edited Dec 13, 2022 7:02AM in Taleo Enterprise 1 comment

Content

I am trying to rip the last 10 characters off of a comment which contains a date, and then determine the difference between that date and the start date, but I am pretty sure I am not formatting correctly as date.

TIMESTAMPDIFF(SQL_TSI_DAY, "Submission Dates"."Offer Actual Start Date", EVALUATE('TO_DATE(%1,%2)' AS DATE,(RIGHT("Requisition Tracking History"."Transaction User Comments" 10),'MM/DD/YYYY'))
 

 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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