Menu

Filtering Using submitTimeUtc

The
submitTimeUtc
field uses date math expressions, which enables you to use dates and times relative to a fixed moment, including the current time which is represented by
NOW
.
You can also use Epoch Time for the start and end time. For example,
submitTimeUtc:[1556712000000 TO 1556757600000
].
Date Math Syntax
Date math expressions consist of either adding some quantity of time in a specified unit, or rounding the current time by a specified unit. Expressions can be joined and are evaluated left to right.
A slash
/
is used to indicate rounding.
NOW/HOUR
represents the beginning of the current hour. If the current time is 4:12 PM (
NOW
), then
NOW/HOUR
would be the start of that hour, 4:00 PM.Valid values in Date Math are:
DAY
or
DAYS
MONTH
or
MONTHS
MINUTE
or
MINUTES
Date Math Range
Date math supports date range searches. The syntax is [startDate TO endDate}.
[
indicates the date is included in the range;
{
indicates the date is excluded.
For example, If we want to search for transactions from the previous day, and the current date is May 3, 2019,
[NOW/DAY-1DAY TO NOW/DAY
} would search for transactions with a date between May 2, 2019, 12:00 AM to May 2, 2019, 11:59 PM.
More Examples
Last hour:
[NOW/HOUR-1HOUR TO NOW/HOUR}
Today:
[NOW/DAY TO NOW/DAY+1DAY}
Yesterday:
[NOW/DAY-1DAY TO NOW/DAY}
Last 7 days:
[NOW/DAY-7DAYS TO NOW/DAY+1DAY}
Month-to-Date:
[NOW/MONTH TO NOW/DAY+1DAY}
Last month:
[NOW/MONTH-1MONTH TO NOW/MONTH}
Last 6 months:
[NOW/DAY-6MONTHS TO NOW/DAY+1DAY}
Back to top