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

  • No labels