Insert clause date tab

One or more clauses define the terms for the creation of the segment. Each clause is true or false for a member, and can be connected to other clauses by using the AND, OR, NOT, or parentheses.

Insert clause date tab UI

The table below explains the options available in Insert clause date tab:

Field Name Description
If this This is used to select exact date and time or anniversary from the drop-down menu
In this field This is used to select the desired date field from the drop-down menu
Is This is used to select the desired command from the drop-down menu
This date

This is used to enter the date in YYYY-MM-DD or YYYY-MM-DD HH:MM:SS format, or click the calendar to select a date

Note

If you do not enter a time, it defaults to YYYY-MM-DD 00:00:00, so implicitly, a time of midnight at the start of the entered date is included in case you selected exact date and time instead of the anniversary.

If you enter NOW in this field, instead of an actual fixed date, the database uses the current system time whenever the segment is run.

Users of Oracle MUST use YYYY-MM-DD formatting, or results may be incorrect

Find two examples below :

  • Creating a clause that says If this exact date and time in this field DateJoined_ is equal to 2002-12-31, it creates a segment for all members whose join date is on or after December 31st, 2002

Note

Members whose join date happened at some time in December. 31st is included because the implicit time you entered is midnight at the start of December 31st. This is a way to create a segment of more recent members. For example. This can be paired with one or more clauses by using AND, OR, NOT, or the parentheses

  • Creating a clause that says If this anniversary in this field ConfirmDat_ is equal to 2002-12-31, it creates a segment for all members whose anniversary of their confirmation date is on December 31st, 2002. This is a way to create a segment of members who joined one year ago to send a 1st year anniversary mailing. For example, this can be paired with one or more clauses by using AND, OR, NOT, or the parentheses