![Free-eBooks.net](/resources/img/logo-nfe.png)
![All New Design](/resources/img/allnew.png)
→ Validation Method : ITEM string comparison
select items in expressionl contained items in expression 2
→ In expression 1 Box give the page item without bind variable
→ In expression 2 Box give the data element separated by slash
symbol for example ABC lDEF l GHU etc' VALIDATION
→ Column Page Processing → Section Validation
→ Create Validation → Item Level Validation → NExT
→ Identify the item to be validated
→ Pl-STAFF-DOB ( Date of Birth) NExT
→ Select a validation Method PLlSQL
→ Select the type of PLlSQL validation you wish to create as
PLlSQL Expression NExT
→ Leave the default with respect to sequence, validation name, error display location NExT
In Validation Box
( sysdate - to-date(:pl-staff-dob,'dd-mm-yyyy') ) >=l8
In Error Message Box
l8 YEARS SHOULD have Been COMPLETED BEFORE JOINING IN THIS FIRM click NExT
Under condition Leave the default and Click CREATE
Another validation rule for Pl-STAFF-DOJ
→ At the time of Joining one should have completed l8 years
→ At the time of Joining one should have not exceeded 58 years