This article supports Audience Studio - Legacy. |
You can use timestamp operators to set a time frame that you want to use in your segment. The timestamp is the time the data came into our system.
All timestamp operators are UNIX timestamps when SQL statements are generated in the processing engine. Operators follow SQL logic.
Operator | Example |
|---|---|
= is date | = is date 2019-10-11 00:00:00 |
not between the past | not between the past 6 - 12 hours |
!<-> not between dates | !<-> not between dates 2019-03-06 06:33:11 - 2019-10-19 12:45:24 |
!= is not date | != is not date 2018-08-01 00:00:00 |
< before date | < before date 2019-06-26 09:36:14 |
not in the past | not in the past 1 quarters |
<-> between dates | <-> between dates 2019-10-09 00:00:00 - 2019-10-11 00:00:00 |
last | last month; last week; last quarter |
this | this week; this month; this quarter; this year |
yesterday | yesterday |
today | today |
in between the past | in between the past 3 - 5 quarters |
<= on or before date | <= on or before date 2019-06-12 01:51:59 |
> after date | > after date 2019-04-04 04:35:54 |
in the past | In the past 5 months |