→ Date of Joining should not be prior to 0l-Jan-200l since the company formed 1 promoted on the said date
Upto validation Box, the earlier said procedure holds good except on the column name as Pl-STAFF-DOJ instead of Pl-STAFF-DOB
In Validation Box
((( to-Date(:pl-staff-doJ,'dd-mm-yyyy') -
to-Date(:pl-staff-dob,'dd-mm-yyyy') ) >= l8),
to-date(:pl-staff-doJ,'dd-mm-yyyy') >= to-Date('0l-0l-200l', 'dd-mm- yyyy'))
In Error Message Box
Either date of Join falls before 0l-Jan-200l or the date of Join falls before completion of l8 years
Now we shall run the application and check whether the validation can get fired at the time of wrong entry itself'