The Segment Timestamp Operators were upgraded as of November 19, 2019. This upgrade was done to make the user experience more intuitive. As part of this upgrade, some operators were kept and changed and others were removed. All timestamp operators are converted to UNIX timestamps when SQL statements are generated in the processing engine. Operators follow SQL logic.
For existing segments, you are able to see and use the current operators. If you create a new segment, you are only able to see and use the new operators. To help you transition to the equivalent new operator, click on the link to the New Timestamps UI as shown in the following.
All existing segments, once edited, saved and reopened, will automatically convert to the new timestamp operator.
Here we have included the original, current, and new operators for your reference.
Original Operator | Current Operators | Example - Current Operators | New Operator | Example - New Operators |
|---|---|---|---|---|
equal to | = is | = is (FixedTimestamp 2019-10-11 00:00:00) | = is date | = is date 2019-10-11 00:00:00 |
is one of | = is (multiple) | = is (multiple) 1530199107, 1530223860, 1530600353 | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
equal to | = is (number) | = is (Number 3) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
equal to | = is (relative) | = is (RealtiveTimestamp (unit) year, last (number) 0) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is not between | !<-> not between (advanced) | !<-> not between (advanced) Last 3rd day to this 3rd day | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is not between | !<-> not between (advanced) | !<-> not between (advanced) Last March until this March | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is not between | !<-> not between (advanced) | !<-> not between (advanced) Last Mon until this Mon | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is not between | !<-> not between (advanced) | !<-> not between (advanced) Last month | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is not between | !<-> not between (advanced) | !<-> not between (advanced) Last Sun until this Sun | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is not between | !<-> not between (advanced) | !<-> not between (advanced) Last year's last quarter | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is not between | !<-> not between (advanced) | !<-> not between (advanced) Last year's same quarter | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is not between | !<-> not between (advanced) | !<-> not between (advanced) Past until last Monday | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is not between | !<-> not between (advanced) | !<-> not between (advanced) Past until this 3rd day | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is not between | !<-> not between (advanced) | !<-> not between (advanced) This quarter until now | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is not between | !<-> not between (advanced) | !<-> not between (advanced) This Sun until now | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is not between | !<-> not between (advanced) | !<-> not between (advanced) This year until now | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is not between | !<-> not between (advanced) | !<-> not between (advanced) Until this July | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is not between | !<-> not between (number) | !<-> not between (Number 1 and Number 100) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is not between | !<-> not between (relative) | !<-> not between ((RelativeTimestamp (unit) hour, last (number)12) and (RelativeTimestamp (unit) hour, last (number) 6)) | not between the past | not between the past 6 - 12 hours |
is not between | !<-> not between (timestamp) | !<-> not between (FixedTimestamp 2019-03-06 06:33:11 and FixedTimestamp 2019-10-19 12:45:24) | !<-> not between dates | !<-> not between dates 2019-03-06 06:33:11 - 2019-10-19 12:45:24 |
not equal to | != is not (fixed) | != is not (FixedTimestamp 2018-08-01 00:00:00) | != is not date | != is not date 2018-08-01 00:00:00 |
is not one of | != is not (multiple) | != is not (multiple) 1530199107, 1530223860, 1530600353 | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
not equal to | != is not (number) | != is not (Number 3) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
not equal to | != is not (relative) | != is not (RealtiveTimestamp (unit) year, last (number) 0) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
less than | < less than (fixed) | < less than (FixedTimestamp 2019-06-26 09:36:14) | < before date | < before date 2019-06-26 09:36:14 |
less than | < less than (number) | < less than (Number 52) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
does not exist or less than | < less than (or null) (fixed) | < less than (or null) (FixedTimestamp 2019-10-16 00:00:00) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
does not exist or less than | < less than (or null) (number) | < less than (or null) (Number 10) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
does not exist or less than | < less than (or null) (relative) | < less than (or null) (RelativeTimestamp (unit) quarter, last (number)1) | not in the past | not in the past 1 quarters |
less than | < less than (relative) | < less than (RelativeTimestamp (unit) month, last (number) 0 | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is between | <-> between | <-> between (FixedTimestamp 2019-10-09 00:00:00 and FixedTimestamp 2019-10-11 00:00:00) | <-> between dates | <-> between dates 2019-10-09 00:00:00 - 2019-10-11 00:00:00 |
is between (time) | <-> between (advanced) | <-> between (advanced) Last 3rd day to this 3rd day | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is between (time) | <-> between (advanced) | <-> between (advanced) Last March until this March | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is between (time) | <-> between (advanced) | <-> between (advanced) Last Mon until this Mon | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is between (time) | <-> between (advanced) | <-> between (advanced) Last month | last | last month |
is between (time) | <-> between (advanced) | <-> between (advanced) Last Sun until this Sun | last | last week |
is between (time) | <-> between (advanced) | <-> between (advanced) Last year's last quarter | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is between (time) | <-> between (advanced) | <-> between (advanced) Last year's same quarter | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is between (time) | <-> between (advanced) | <-> between (advanced) Past until last Monday | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is between (time) | <-> between (advanced) | <-> between (advanced) Past until this 3rd day | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is between (time) | <-> between (advanced) | <-> between (advanced) This quarter until now | this | this quarter |
is between (time) | <-> between (advanced) | <-> between (advanced) This Sun until now | this | this week |
is between (time) | <-> between (advanced) | <-> between (advanced) This year until now | this | this year |
is between (time) | <-> between (advanced) | <-> between (advanced) Until this July | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is between (time) | <-> between (advanced) | <-> between advanced, (relative (unit) day, last (number) 1, (duration) 1 day) | yesterday | yesterday |
is between (time) | <-> between (advanced) | <-> between advanced, (relative (unit) day) | today | today |
is between (time) | <-> between (advanced) | <-> between advanced, last quarter (relative (unit) quarter, last (number) 1, (duration) 1 quarter) | last | last quarter |
is between (time) | <-> between (advanced) | <-> between advanced, this month until now (relative (unit) month) | this | this month |
is between | <-> between (number) | <-> between (Number 52 and Number 54) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
is between | <-> between (relative) | <-> between ((RelativeTimestamp (unit) quarter, last (number) 5) and RelativeTimestamp (unit) quarter, last (number) 3) | in between the past | in between the past 3 - 5 quarters |
less than or equal to | <= at most (fixed) | <= at most (FixedTimestamp 2019-06-12 01:51:59) | <= on or before date | <= on or before date 2019-06-12 01:51:59 |
less than or equal to | <= at most (number) | <= at most (Number 50) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
does not exist or less than or equal to | <= at most (or null) (fixed) | <= at most (or null) (Fixed Timestamp 2017-08-23 09:10:53) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
does not exist or less than or equal to | <= at most (or null) (number) | <= at most (or null) (Number 10) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
does not exist or less than or equal to | <= at most (or null) (relative) | <= at most (or null) (RelativeTimestamp (unit) day, last (number) 0) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
less than or equal to | <= at most (relative) | <= at most (RelativeTimestamp (unit) hour) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
greater than | > greater than (fixed) | > greater than (FixedTimestamp 2019-04-04 04:35:54) | > after date | > after date 2019-04-04 04:35:54 |
greater than | > greater than (number) | > greater than (Number 52) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
does not exist or greater than | > greater than (or null) (fixed) | > greater than (or null) (FixedTimestamp 2019-03-20 05:10:25) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
does not exist or greater than | > greater than (or null) (number) | > greater than (or null) (Number 10) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
does not exist or greater than | > greater than (or null) (relative) | > greather than (or null) (RelativeTimestamp (unit) day, last (number) 0) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
greater than | > greater than (relative) | > greater than (RelativeTimestamp (unit) month, last (number) 0 | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
greater than or equal to | >= at least (number) | >= at least (Number 192) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
does not exist or greater than or equal to | >= at least (or null) (fixed) | >= at least (or null) (Fixed Timestamp 2017-08-23 09:10:53) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
does not exist or greater than or equal to | >= at least (or null) (number) | >= at least (or null) (Number 10) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
does not exist or greater than or equal to | >= at least (or null) (relative) | >= at least (or null) (RelativeTimestamp (unit) day, last (number) 0) | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
greater than or equal to | >= at least (relative) | > = at least, (RelativeTimestamp, (unit) month, last (number) 5) | in the past | In the past 5 months |
greater than or equal to | >= at least (fixed) | >= at least (FixedTimestamp 2017-08-23 09:10:53) | >= on or after date | >= on or after date 2017-08-23 09:10:53 |
contains | contains | contains 1530755859 | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
ends with | ends with | ends with 0 | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
exists | is not null | is not null | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
does not exist | is null | is null | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
does not contain | not contains | not contains 1530223860, 1530755859,1530529619 | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
does not end with | not ends with | not ends with 1529551826, 1530146097 | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
not ends with | not ends with | not ends with 0 | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
does not match regex | not regex | not regex 3 | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
does not start with | not starts with | not start with 1530199107 | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
matches regex | regex | regex 1420066800 | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |
starts with | starts with | starts with 1 | No longer supported | Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI |