Set up validation rule of type Range expression

Use validation rules to check if the data is in line with the defined standards.

To validate data, you can use several validation types. This topic explains how to set up a validation rule of type Range expression.

Use a range expression validation rule to validate if a field value is within a defined range. To define a range expression, you can use a:

• Fixed value or a range of values using the advanced query syntax.

• Static method that defines the range. For example, you can use the SysQueryRangeUtil class to apply advanced date queries.

For each validation rule, you can set up:

• A validation message that is shown if the validation rule is not met.

• Conditions to define the data to which the rule applies.

Flow diagram