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