Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood 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" =
Tagged:
0