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:
- 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.