This content has been marked as final. Show 5 replies
All what you have to do is:
Edit your page. Under Page Processing
Right click on Validating and choose create new validation.
Choose your Tabular Form, then choose approve_date .
Validation Type: SQL expression.
:APPROVE_DATE > sysdate
You can throw your message in the box of:
If you believe that my answer was correct or helpful, then please mark the answer as helpful or correct ....
I wants to do multiple validations on date fields on click of submit button.
I have three date fields: applied_date, approved_date, reject_date. Validation details are given below,
IF approved_date IS NOT NULL and reject_date IS NOT NULL THEN
Error message 'Either approved_date or reject_date should enter';
ELSIF approved_date IS NOT NULL and reject_date IS THEN
IF approved_date<applied_date THEN
Error message 'aprroved_date should not be less than applied date';
ELSIF approved_date IS NULL and reject_date IS NOT THEN
IF reject_date<applied_date THEN
Error message 'reject_date should not be less than applied date';
I tried with creating validation in page processing but the above validation is not working.
Please suggest me how to achieve this.
Thanks & Regards,