One of the most powerful ways to target groups of customers is by those who took a specific action on a certain date, within a specified date range, or if simply took the action at all. Target customers by subscription date, how they are engaging with your emails, or what they have purchased.

How the Operators Work

When using date filters in the Segment Filter 2.0 system there are three ways in which a date can be calculated - Relative timeframe, Absolute timeframe, or the State (value or no value). Relative and Absolute operators are used to reference a range of time or a single 24 hour day a contact performed an action, whereas the State operators are used to target contacts that simply have a date value in a profile field.

Relative Date Operators

The relative operators compare time (days, weeks, months, or years) against today; there are 6 different choices for this option.

Is Today: Calculates the action occurring today between 12:00:01am ET through 11:59:59am ET.

Operator/Value

Date Range Calculated

Visual Example

Is Today

Today

Is More Than: Calculates the action occurring before the Start of Day (12:00:01am ET) of X day. 💡 X day is excluded.

Operator/Value

Date Range Calculated

Visual Example

Is More Than 0 Day(s) ago

Every day in the past through EOD yesterday

- excludes today

Is More Than 1 Day(s) ago

Every day in the past through EOD 2 days ago

- excludes yesterday and today

Is More Than 2 Day(s) ago

Every day in the past through EOD 3 days ago

- excludes last 2 days and today

Is More Than 3 Day(s) ago

Every day in the past through EOD 4 days ago

- excludes last 3 days and today

Is More Than 1 Week(s) ago

Every day in the past through EOD 8 days ago

- excludes last 7 days and today

Is More Than 2 Week(s) ago

Every day in the past through EOD 15 days ago - excludes last 14 days and today

Is More Than 1 Month(s) ago

Every day in the past through EOD 31 days ago - excludes last 30 days and today

Is More Than 1 Year(s) ago

Every day in the past through EOD 366 days ago

- excludes last 365 days and today

n/a

Is Exactly: Calculates an action occurring from 12:00:01am - 11:59:59am ET on the X number of day(s), week(s), month(s), or year(s) that happened in the past. Use this operator to target a single day.

Operator/Value

Date Range Calculated

Visual Example

Is Exactly 0 Day(s) ago

Today

Is Exactly 1 Day(s) ago

Yesterday

Is Exactly 2 Day(s) ago

On the 2nd day before today

Is Exactly 1 Week(s) ago

On the 7th day before today

Is Exactly 2 Week(s) ago

On the 14th day before today

Is Exactly 1 Month(s) ago

On the 30th day before today

Is Exactly 1 Year(s) ago

On the 365th day before today

n/a

Is Less Than: Calculates the action occurring after the End Of Day (11:59:59pm ET) of X day through the End Of Day (11:59:59pm ET) today. 💡 X day is excluded.

Operator/Value

Date Range Calculated

Visual Example

Is Less Than 1 Day(s) ago

Today

Is Less Than 2 Day(s) ago

SOD yesterday through EOD today

Is Less Than 3 Day(s) ago

SOD 2 days ago through EOD today

Is Less Than 1 Week(s) ago

SOD 6 days ago through EOD today

Is Less Than 2 Week(s) ago

SOD 13 days ago through EOD today

Is Less Than 1 Month(s) ago

SOD 29 days ago through EOD today

Is Less Than 1 Year(s) ago

SOD 364 days ago through EOD today

n/a

Is Between: Calculates the action occurring between the Start of Day (12:00:01am ET) on the first day through the End of Day (11:59:59pm ET) on the second day.

Operator/Value

Date Range Calculated

Visual Example

Is Between 1 and 0 Day(s) ago

SOD yesterday through EOD today

Is Between 4 and 1 Day(s) ago

SOD 4 days ago through EOD yesterday

Is Between 14 and 5 Day(s) ago

SOD 14 days ago through EOD 5 days ago

Is Between 2 and 1 Week(s) ago

SOD 14 days ago through EOD 8 days ago

Is Not Between: Calculates any action occurring before the Start of Day (12:00:01am ET) on the first day and after the End of Day (11:59:59pm ET) on the second day through End of Day (11:59:59pm ET) today. Use this option to exclude a time period.

Operator/Value

Date Range Calculated

Visual Example

Is Not Between 12 and 5 Day(s) ago

Every day through EOD 13 days ago AND

SOD 4 days ago through EOD today

- excludes SOD 12 days ago through EOD 5 days ago


Absolute Date Operators

The absolute operators compare time against an exact calendar date; there are 5 different choices for this option.

💡 Examples are using December 31, 2021, as 'today'

Is After: Calculates the action occurring after the End of Day (11:59:59pm ET) of the specific date through the End of Day (11:59:59pm ET) today. 💡 The specified date is excluded.

Operator/Value

Date Range Calculated

Visual Example

Is After December 15, 2021

Starting December 16, 2021, through EOD today (relative)

Is On: The 24-hour timeframe (12:00:01am - 11:59:59am ET) an action occurred on. Use this operator to target a single calendar date.

Operator/Value

Date Range Calculated

Visual Example

Is On December 31, 2021

December 31, 2021

Is Before: Calculates the action occurring before the Start of Day (12:00:01am) of X date. 💡 The specified date is excluded.

Operator/Value

Date Range Calculated

Visual Example

Is Before December 31, 2021

Every day through the EOD of December 30, 2021.

Is Between: Calculates the action occurring between 12:00:01am on the first date through 11:59:59pm on the second date.

Operator/Value

Date Range Calculated

Visual Example

Is Between December 5, 2021 - December 20, 2021

SOD December 5, 2021, through EOD December 20, 2021

Is Not Between: Calculates any action occurring before 12:00:01am on the first date and after 11:59:59pm on the second date through 11:59:59 today. Use this option to exclude a date range.

Operator/Value

Date Range Calculated

Visual Example

Is Not Between December 5, 2021 - December 20, 2021

Every day through EOD December 4, 2021,

AND

SOD December 21, 2021, through EOD today

- excludes SOD December 5 through EOD December 20


State Operators

If a date range is irrelevant, choose either of the selectors under the State option to target this group of contacts:

  • Is Unknown: The profile field is empty.

  • Has Any Value: The profile field is not empty.


💡 Helpful Tips

  • Calculations happen within a 15-minute window in real-time.

  • A day is from 12:00:01am - 11:59:59am ET.

  • A week is 7 days.

  • A month is 30 days, regardless of the number of days in a month.

  • A year is 365 days, regardless of the number of days in the year.

  • The value '0' equals today.

  • Use this key for the visual examples in the tables above:

Did this answer your question?