dkvnewoptions
MIS
I have a form that has a series of fields dealing with date and time and I need to validate that the data entered is correct when the customer leaves the field. I have tried using the format validation rules without success.
The first field is "Class Date" it is defined with a Short Date format. I need to verify that the date entered is less then or equal the current date, when the customer tabs to the next field.
The next four fields are text fields "Start1", "End1", Start2" and "End2". If "Start1" is not blank then "End1" must be filled in and > then "Start1". If "Start2" is not blank then "Start1" and "End1" must have been filled in and "Start2" must be greater then "End1". The same rules apply to "End2" it must be > then "Start2" and "Start1", "End1" and "Start2" must have been completed".
The first field is "Class Date" it is defined with a Short Date format. I need to verify that the date entered is less then or equal the current date, when the customer tabs to the next field.
The next four fields are text fields "Start1", "End1", Start2" and "End2". If "Start1" is not blank then "End1" must be filled in and > then "Start1". If "Start2" is not blank then "Start1" and "End1" must have been filled in and "Start2" must be greater then "End1". The same rules apply to "End2" it must be > then "Start2" and "Start1", "End1" and "Start2" must have been completed".