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

I need an SQL to extract ONLY the learner who have a completion date equal to Today minus 10 days

Summary:

I want to create a BI Analysis for assignment criteria that extract ONLY the learner who completed a specific learning item 10 days ago.

Content (please ensure you mask any confidential information):

I want to create a BI Analysis for assignment criteria that extract ONLY the learner who completed a specific learning item 10 days ago.

I've worked with the between (BETWEENtimestampadd (SQL_TSI_DAY,-60,CURRENT_DATE) AND CURRENT_DATE) to extract events between date, but now I need a specific 10 days after the completion date.

How can I write an SQL filter for this?

"Workforce Learning - Learning Management Real Time"."Learning Record Details"."Completion Date" =

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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