Date Range Prompts

Extensive options are available from the field displaying the prompts available for date expressions that use the is within option.

The following options are available:

• Current — Returns all records in which the date occurs in the Current Week, Month, Quarter, or Year.

• Today / Yesterday — Returns all records in which the date matches the current date (or yesterday).

• To Date — Returns all records in which the date occurred in the last Week, Month, or Year To Date.

• Last — Returns all records in which the date occurred in the Last Week, Month, x Days, x Months, and so on.

• Next — Returns all records in which the date will occur in the Next 14 Days, Next x Months, and so on.

• Last / Next — Returns all records in which the date occurred in the Last x Days / Months and all records in which the date will occur in the Next x Days / Months.

• All / Next — Returns all records in which the date has already occurred and all records in which the date will occur within the next x days / months.

• Days Ago or More — Returns all records in which the date occurred x (or more) Days Ago.

• Days from Expiration — Returns all records in which date will expire within a given number of days (or date has already expired).

  Functionally, this option works similarly to All / Next, but provides more options appropriate for date expiration.

• Value does not exist — Returns all records in which the date field is empty / blank.

• Value exists — Returns all records in which the date field contains a value (is not empty / blank). 

Maintenance Connection weeks are calculated from Sunday through Saturday.