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
Windows System Information File
Viewed 256 times since Wed, Dec 5, 2018

Setting Up E-mail Notifications
Viewed 158 times since Wed, Dec 5, 2018

Creating Transitions
Viewed 71 times since Wed, Dec 5, 2018

About CSV Import
Viewed 131 times since Wed, Dec 5, 2018

Software Service Agreement
Viewed 82 times since Wed, Dec 5, 2018

Setting Up Personal Notifications
Viewed 123 times since Wed, Dec 5, 2018

How to Read the Log
Viewed 82 times since Wed, Dec 5, 2018

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

Deactivating a Local User
Viewed 70 times since Wed, Dec 5, 2018

Displaying The Dashboard In The Full Screen Mode
Viewed 83 times since Wed, Dec 5, 2018