Search Builder

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.

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.