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
Skip to content
  • 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'))
     

     

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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