Date Range Prompts

There are extensive options for date expressions that use the is within and is not within options.

Maintenance Connection weeks are calculated from Sunday through Saturday.

The options can be summarized as follows:

• 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). In this example, is within is more easily understood as is, since the selected value is not a range of dates.

• …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. For example, the Target Date criteria could be configured as any date within the Last 3 Months.

• Next…: Returns all records in which the date occurs in the Next 14 Days, Next x Months. For example, the Warranty Ends Date criteria could be configured as any date within the Next 6 Months.

• Last / Next…: Returns all records in which the date occurred in the Last x Days/Months and all records in which the date occurs 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 occurs within the next x Days/Months. For example, the Warranty Ends Date criteria could be configured to return all assets with a warranty that expires in the next three months, including assets for which the warranty has already expired.

• … 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 expires within a given number of days, or the 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).