Using date comparators in a segment
You can use a date comparator to compare specific dates or durations in rule conditions. All date comparators are based on Universal Coordinated Time (UTC) and not your organization’s timezone.
The following table describes date comparators you can use when creating segments:
| Date comparator | Description |
|---|---|
| is in the past | Verifies that the date value is in the past specified number of days, weeks, months, or years. This calculation is based on UTC, not your organization’s timezone. For example, you might want to include results that fall within the past 3 days. This might return an unexpected result, if the current time of your organization’s timezone falls a day ahead ahead of UTC. The system includes results for the past 3 days for UTC (13-15 OCT) and not for the last 3 days (14-16 OCT) of your organization’s timezone. (Your local date and current time: 16 OCT 2020 10:00. UTC date and current time: 15 OCT 2020 23:00.) |
| is not in the past | Verifies that the date value is not in the past specified number of days. This calculation is based on UTC, not your organization’s timezone. |
| is in the next | Verifies that the date value is in the next specified number of days, weeks, months, or years. This calculation is based on UTC, not your organization’s timezone. |
| is not in the next | Verifies that the date value is not in the next specified number of days. This calculation is based on UTC, not your organization’s timezone. |
| is now plus | Verifies that the date value is on the future specified number of days or number of weeks. This calculation is based on UTC, not your organization’s timezone. |
| is now minus | Verifies that the date value is on the past specified number of days or number of weeks. This calculation is based on UTC, not your organization’s timezone. |
| is on the day | Verifies that the date value is on the specified day. This calculation is based on UTC, not your organization’s timezone. |
| is not on the day | Verifies that the date value is not on the specified date. This calculation is based on UTC, not your organization’s timezone. |
| is between | Verifies that the date value is between the range of specified dates. This calculation is based on UTC, not your organization’s timezone. |
| is not between | Verifies that the date value is not between the range of specified dates. This calculation is based on UTC, not your organization’s timezone. |
| is before | Verifies that the date value is before the specified date. This calculation is based on UTC, not your organization’s timezone. For example, you might want to include results that fall before 15 OCT (according to your timezone). This might return an unexpected result if your organization’s timezone falls a day ahead of UTC, because the calculation would also include results for 16 OCT (according to your timezone). |
| is after | Verifies that the date value is after the specified date. This calculation is based on UTC, not your organization’s timezone. For example, you might want to include results that fall after 15 OCT (according to your timezone). This might return an unexpected result if your organization’s timezone falls a day ahead of UTC, because the calculation would also include results for 16 OCT (according to your timezone). |
| is in the year | Verifies that the date value is in the specified year. This calculation is based on UTC, not your organization’s timezone. |
| is not in the year | Verifies that the date value is not in the specified year. This calculation is based on UTC, not your organization’s timezone. |
If you have suggestions for improving this article, let us know!