Date Field Expressions
Rule Criteria Expressions based on date fields offer extensive options to dynamically generate rules. If a value has already been defined for a field it will be displayed.
For all date fields, you can specify that dates should be within, before, after, or between certain dates. The options in the field that define the relationship between the field value and the specified date or date range are as follows:
-
Selecting is within allows you to select from a series of date ranges to complete your criteria, such as current year, quarter to date, last 6 months, last / next year, and so on. These options also allow you to specify that the value must exist (Value Exists) or should be blank/empty (Value does not Exist).
For a more complete description of the options available, see the section on Date Range Prompts.
The remaining options in the field allow you to enter a specific date (or dates for a date range). No additional choices will be available.
-
Selecting is allows you to enter a specific date that the field should possess. For example: Target Date is 03/01/2010.
-
Selecting is between will prompt you to enter two specific dates to define your own date range. For example: Target Date is between 03/01/2010 and 03/15/2010.
-
Selecting is after allows you to enter the specific date that the field value should follow. For example: Target Date is after 03/01/2010.
-
Selecting is before allows you to enter a specific date that the field value should precede. For example: Target Date is before 03/01/2010.
-
Selecting is not allows you to enter a specific date to exclude. For example: Target Date is not 03/01/2010.
Dates can be entered as mm/dd/yyyy or m/d/yyyy or m/d/yy. For example, March 1st, 2010 can be entered as 03/01/2010 or 3/1/10.
