Get Started: AI Resources for Oracle Cloud HCM – Go Here

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

Years of Service Formula

User_2025-01-30-21-33-03-247

User_2025-01-30-21-33-03-247 Green Ribbon

Jun 19, 2018 4:17PM edited Oct 29, 2018 2:55PM in Reporting and Analytics for HCM 2 comments

0

Answers

Deb Luisi Bronze Medal

Jun 19, 2018 4:24PM edited Jun 19, 2018 4:24PM

Hi Michael, I use YOS often and use the following formula: TIMESTAMPDIFF(SQL_TSI_YEAR, "Work Relationship Details"."Original Date Of Hire", CURRENT_DATE) Hope this helps.

0
Julian Challenger-Oracle Jadeite

Jun 19, 2018 4:33PM edited Jun 19, 2018 4:33PM

Please use Workforce Management - Work Relationship Real Time. This has years of service.

2