Comindware Knowledgebase

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 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 task and set the finish date. Move the workflow task 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 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 task and set the finish date earlier than the start date. Move the workflow task 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.

Send you request to Comindware Still need help? Contact us

See Also

Back to top