Using the correct date format

Keep in mind two aspects when you wish to segment using a date:

If you are comparing dates (for instance, emails opened within X and Y), use the YYYY-MM-DD date format.
If you are using dates from your database (eg, birthday segment), input the exact same date format as your database. For instance, if your birthday fields were input as DD-MM-YY, you need to use the same format (ex: 15-12-83, not 83-12-15).

-

Using future dates

For some parameters, you can refer to specific dates in the future.

💡 These conditions are limited to a few selected conditions (most regarding loyalty program values).

-

Using date variables

When using conditions on dates, you can use variables to dynamically select the current day’s date, as used in the birthday filter example below.

$day$ => current day
$month$ => current month
$year$ => current year

💡 Remember that, for custom database fields, you need to use the exact format you entered. If your database dates use the format DD-MM-YYYY and want to use the variables, enter --. If you use the format YYYY/MM/DD, use //.

-

Using date ranges

For all types of events, Splio allows you to select a time range.

If you need to find all contacts who clicked on a link when the promotional offer was in force, you can use two fixed dates (image 2).

Alternatively, if for instance, you need to send a survey to everybody between 30 and 60 days ago since they signed up for your newsletter, you can use dates as shown in image 3.

Understanding the conditions and operators in filters