Evaluate equality between date values

Date comparison evaluates a match for one of several date increments.

About this task

You can specify granularity to the hour, day, week, month, quarter, or year. For example, the filter [Created on] [is same] [Week] as [Closed] returns records that were closed in the same week that they were opened. When you run this type of filter, be sure to specify the year in an additional filter condition of [Created] [is same] [Year] as [Closed] to eliminate records that were created a year before they were closed.
Figure 1. Date field comparison

Procedure

  1. In the condition builder, create a new condition.
  2. Select a date field from the left operand choice list.
  3. Select [is same] or [is different] from the operator choice list.
    An additional choice list appears.
  4. Select the granularity from the date range choice list.
    Table 1. Date range descriptions
    Date Range Description
    Hour Filters on the hour of the day.
    Day Filters on the day of the month, not the date. For example, a Day value of the 1st of August matches with a Day value of the 1st of September.
    Week Filters on the week of the year. ServiceNow defines a week as Sunday through Saturday for the purposes of Field Comparison.
    Month Filters on the month of the year. For example, any date within December returns the 12th month of the year.
    Quarter Filters on the quarter of the year.
    Year Filters on the year.
  5. Select a different date field from the right operand choice list.
  6. Click Run.