Adding a Label if Background Check Was completed within 90 days. — Cloud Customer Connect
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

Adding a Label if Background Check Was completed within 90 days.

edited Jul 17, 2025 4:15AM in Recruiting, Opportunity Marketplace 1 comment

I am working on a Candidate Selection Process (CSP) fast formula to label candidates who have completed their background screening within 100 days of applying. The goal is to return 'Y' if a candidate’s screening is completed within 100 days and 'N' otherwise. We want this applied to all candidates across requisitions.

I have successfully implemented a similar logic for identifying internal employees based on person type, using a value set and fast formula that fetch historical person types with SUBMISSION_ID as a parameter.

Based on this approach, I want to build a value set and fast formula that:

  • Checks the latest background screening completion date (

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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