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.

Attachments
There are no attachments for this article.
Feedback
Security Code
Related Articles
What should I do if a product serial number is lost?
Viewed 127 times since Wed, Dec 5, 2018

Field Read/Write Permissions
Viewed 230 times since Wed, Dec 5, 2018

Registering Products at Comindware Website
Viewed 215 times since Wed, Dec 5, 2018

Functions
Viewed 136 times since Wed, Dec 5, 2018

Mandatory Fields
Viewed 226 times since Wed, Dec 5, 2018

Literals
Viewed 136 times since Wed, Dec 5, 2018

Comindware Data Security in Cloud
Viewed 107 times since Thu, Oct 1, 2020

How To Change Task Status
Viewed 180 times since Wed, Dec 5, 2018

Configuring Account Settings
Viewed 126 times since Wed, Dec 5, 2018

Who is a Report Owner
Viewed 182 times since Wed, Dec 5, 2018