Need Guidance on Implementing Seniority Date Validation

Dear Team,

We’re currently working on a business-critical requirement and need your expert guidance. Below is the summary of the scenario and the corrections needed:

1. Seniority date exceeding the hire date:

Issue: In some records, the seniority date is later than the hire date.
Required Correction: The seniority date must always be less than or equal to the hire date.

2. Blank seniority date:

Issue: In certain cases, the seniority date field is left blank.
Required Correction: The seniority date field should be mandatory and must not be left blank.

We’d like to know if there’s a feasible way to implement validations for these scenarios in the Test Environment before rolling them out to production.