Today is after

Determines the number of days the current system date is after a specified date.

Match all Contacts with a Created Date 7 days ago.

Today is before

Determines the number of days the current system date is before a specified date.

Match all Contacts 5 days before an Expiry date.

Today is after last anniversary of

Determines the number of days the current system date is after the last anniversary of a specified date.

Match Contacts 7 days after the anniversary of their Created Date.

Today is before next anniversary of

Determines the number of days the current system date is before the last anniversary of a specified date.

Match Contacts 3 Days before their birthday.

Today is the Same day of the week as

Determines if the current system date falls on the same day of the week as a specified date.

Match Contacts on the same day of the week as their registration date.

Today is the Same Day of the Month as

Determines if the current system date falls on the same day of the month as a specified date.

Match Contacts on the same day of each month, a billing date.

Today has the Same Month as

Determines if the current system date is in the same month of the year as a specified date.

Match Contacts on same month as registered to give them a special offer in their anniversary month each year.

Today has the Same Year as

Determines if the current system date is in the same year as a specified date.

Match Contact on same year as registered, to make a special offer available until the end of that year.

Day of the week of

Determines if the week day of a specified date matches the specified day.

Match all Contacts that were suspended on a Monday.

Day in Month of

Determines if the day of the month of a specified date matches the specified day.

Match all Contacts that were created on the 2nd day of the month.

Month of

Determines if the month of a specified date matches the specified month.

Match all Contacts with a Created date in September.

Year

Determines if the year of a specified date matches the specified year.

Match all Contacts with a Created date in 2008.

Mode

• Today is after
• Today is before
• Today is after last anniversary of
• Today is before next anniversary of

Date Column

Allows you to select the date column that you would like to match on. The available options are the date fields in the Contact records for this partition.

For example, Created Date or Suspended Date or custom date fields such as Birthday.

You can also specify a fixed date by selecting Specify from the list.

By

Allows you to determine the number of days from the current day to match.

For example, specifying a value of 7 you could match all Contacts with a Created Date 7 days ago.

There are two ways this can be done:

• By if you click By from the list, then you can specify the number of days in the N (Days) field.
• By(variable) you can click any numeric field from a Contact's record and this will be used to determine the number of days from the current day to match.

  For example, a custom field could be included on the Contact's record that specifies the number of days after sign up they would like to be contacted.

Operator

Allows you to select one how the N (Days) field will be matched.

The following options are available:

• = True when the field is equal to the specified value.
• > True when the field is greater than the specified value.
• >= True when the field is greater than or equal to the specified value.
• < True when the field is less than the specified value.
• <= True when the field is less than or equal to the specified value.
• <> True when the field is not equal to the specified value.

N (Days)

If N= is set to Specify, Days Offset allows you to specify the number of days offset.

If N= is set to something other than Specify then leave +Days Offset blank.

Or Default

If By(variable) is selected leave Default N as blank or 0. Otherwise, if a numerical field is selected you can specify the default value to use when that field has no value.

Mode

• Today is the Same Day of the Week as
• Today is the Same Day of the Month as
• Today has the Same Month as
• Today has the Same Year as

Date Column

Allows you to select the date column that you would like to match on. The available options are the date fields in the Contact records for this partition.

For example, Created Date or Suspended Date or custom date fields such as Birthday.

N Days

Available on the Today is the Same Day modes. Allows you to determine the number of days from the current day to match. Positive or negative numbers can be used.

For example, by specifying a value -3, you can match Contacts every month, 3 days before their billing due date.

Mode

• Day of the Week of
• Day in Month of
• Month of
• Year of

Date Column

Allows you to select the date column that you would like to match on. The available options are the date fields in the Contact records for this partition.

For example, Created Date or Suspended Date or custom date fields such as Birthday.

Operator

Allows you to select one how the Day, Month or Year field will be matched.

The following options are available:

• = True when the field is equal to the specified value.
• > True when the field is greater than the specified value.
• >= True when the field is greater than or equal to the specified value.
• < True when the field is less than the specified value.
• <= True when the field is less than or equal to the specified value.
• <> True when the field is not equal to the specified value.

Day, Month or Year

Depending on the Mode selected, allows you to determine the day, month or year to match on.