When specifying a date, it is possible to choose a specific date, specify that the date matches a value entered in another project field, or requires that the date matches the query date. How the two values should connect is determined by the selected operator.


Date format

Multiple date types can be used to specify the period covered by an event.       

Date Type
Description
Date
(YYYY.MM.DD HH:MM)
Date format used by default
Date
(YYYY.MM.DD)
Date, regardless of the time
Year and month
(YYYY.MM)
Any date in the specified month and year
Year
(YYYY)
Any date in the specified year
Month and day
(MM.DD)
Specific month and day, regardless of the year (useful for sending birthday messages)
Month
(MM)
Specific month, regardless of the year
Day
(DD)
Specific day, regardless of the month (such as the 23rd day of the month)
Hour and minutes
(HH:MM)
Specific time, in hours and minutes, regardless of the date
Hour
(HH)
Specific time, in hours only, regardless of the date


Operators         

To target a date or period, you must combine the date type with an operator, as well as with the searche value.

Operators vary between data type, and also between date types.

View the list of operators, and how they are used


Value

In the advanced edit mode, you can target a date or period in various ways, as in simple edit mode, you can only specify a value.


Simple
edit
mode
Advanced
edit
mode

Value
or
Fixed value
X
X
Option indicating that the date must match a fixed value. This option is the most common and requires that you enter a date or select one from the calendar. If a time value is included in the date format, or if the value only refers to the time in hours and minutes, you will also need to enter these.
Field

X
Option indicating that the date must match a value contained in one of the project date fields, selected from the drop-down list.
Query time

X
Option indicating that the date must correspond to the query date. The query date is the date on which the group will be used (usually when viewing or preparing a mailing). A group based on this criteria will target different contacts depending on when it is generated. Other options can be added if you also select Relative date (computed). In such a case, you can add or remove days, months, years, etc. from the current date. For example, to find a date in the past, you must remove days from the current date.