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 (