Segments: New Segment: Insert Clause: Date

One or more clauses define the terms for 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.

If this

Select "exact date and time" or "anniversary" from the drop-down menu.

in this field

Select the desired date field from the drop-down menu.

is

Select the desired command from the drop-down menu.

this date

Enter the date in YYYY-MM-DD or YYYY-MM-DD HH:MM:SS format. Note that if you do not enter a time it will default to YYYY-MM-DD 00:00:00, so implicitly, a time of midnight at the start of the entered date is included (if you selected "exact date and time" instead of "anniversary"). If you enter "NOW" in this field, instead of an actual fixed date, the database will use the current system time whenever the segment is run.

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

Example:

Creating a clause that says "If this exact date and time in this field DateJoined_ is = equal to 2002-12-31", will create a segment for all members whose join date is on or after December 31st, 2002. Note that members whose join date happened at some time on Dec. 31st will be included, because the implicit time you entered is midnight at the start of Dec 31st. This would be 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.

Example 2:

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

More

1. Segments

2. Segments Main Page

3. Segments: New Segment

1. Segments: New/Edit Segment: Essentials

1. Segments: New Segment: Insert Clause: Text

2. Segments: New Segment: Insert Clause: Numeric

3. Segments: New Segment: Insert Clause: Date

4. Segments: New Segment: Insert Clause: Action

5. Segments: New Segment: Insert Clause: Clickthrough

6. Segments: New Segment: Insert Clause: Clickstream

7. Segments: New Segment: Insert Clause: Purchase

8. Segments: New Segment: Insert Clause: Interest

9. Segments: New Segment: Insert Clause: Survey