Validate Entered Dates
Validation of entered date
You can set the rule which validates the entered date. For example, let's specify the date that cannot be a finish date for a project.
To add the rule:
1. Open a workspace, open a workflow app inside a workspace and click «Fields».
2. Create the «Finish Date» field (ID: Finish_Date) of the Date/Time type and drag it to the form.
3. Go to «Workflow Scheme» and click a required step or transition.
4. Go to «Validation Rules» and click «Add Rule» to create a new rule. Type the following expression as the rule for the finish date verification:
| EQUALS($Finish_Date,DATE("2013-01-01T00:00:00Z")) |
5. Type the rule name and the validation message that will be displayed if entered data don't match the rule conditions. Click «Save».
To check how it works, create a new workflow item and set the finish date. Move the workflow item through workflow. On entering the required step or on performing the required transition the validation message will be shown to you if you set the invalid date. You must fix the date to go further.
Finish date cannot be earlier than start date
You can set the rule specifying that the item finish date cannot occur before the item start date.
To add the rule:
1. Create one more field of the Date/Time type for the start date and drag it to the form (name: Start Date, ID: Start_Date).
2. Go to «Workflow Scheme» and click required step or transition.
3. Click «Add Rule» to create a new rule and type the following expression as the rule for the start and finish date verification:
| GREATER($Start_Date,$Finish_Date) |
4. Type the rule name and the validation message text. Click «Save».
To check how it works, create a new workflow item and set the finish date earlier than the start date. Move the workflow item through workflow. On entering the required step or on performing the required transition the validation message will be shown to you. You must fix the dates to go further.
