Days Since Date
===============

This Condition, located on the Miscellaneous category tab in Search Builder,
compares the number of days that have passed since a specific calendar date
to a number of days that you enter.

How to Use It
-------------

Enter a `Date` and a number of `Days`, then choose a `Comparison`.
Search Builder calculates how many days have passed between the date you
entered and today, and compares that number to the value you supplied.

.. note::
    This Condition does not filter person by person. It evaluates the same
    for every record, so it returns either everyone or no one depending on
    whether the elapsed days meet the comparison. It is designed to be
    combined with other Conditions to make a saved search time-aware, such
    as a query that should only return results once a certain number of days
    have passed since a fixed date.

.. admonition:: Example

    Suppose you want a saved search that returns everyone who registered for
    the Fall Retreat, but only once at least 7 days have passed since the
    retreat ended, so an automated follow-up email does not go out too early.
    Combine two Conditions with `AND`:

    - `Member of an Involvement` (or `Registered for` the retreat Involvement),
      to select the registrants.
    - `Days Since Date`, with the `Date` set to the retreat's end date, the
      `Comparison` set to `Greater Equal`, and `Days` set to ``7``.

    Until 7 days have passed, the `Days Since Date` Condition matches no one,
    so the combined search returns an empty list. On day 7 and after, it
    matches everyone, so the combined search returns just the retreat
    registrants.

.. seealso::
    | :doc:`QB-DaysSinceDateField`

|
|

+--------------------+------------------+
| **Latest Update**  |  **07/08/2026**  |
+--------------------+------------------+

New article