Evaluating unequal dates within a range

You can compare unequal date field values by evaluating whether two dates fall within a certain range of each other.

For example, you can create a filter of [Created on] [is more than] [3] [Months] [before] Closed] to display all records that were created at least three months before they were closed. The numerical value specified, such as the value 3 in the example, must be an integer of no more than two digits. If you need to evaluate a difference larger than 99 units, select a less granular unit of time, such as Months instead of Days.
Figure 1. Unequal dates field omparison
Table 1. Choice field date comparison choices
Choice field Date Comparison Choices
Operator is more than, is less than
Unit of time Hours, Days, Weeks, Months, Quarters, Years
Relative position of dates before, after, before or after