Filtering Using the submitTimeUtc Field

The

submitTimeUtc

field uses date math expressions and 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 UNIX Epoch Time for the start and end time. For example,

submitTimeUtc:[1556712000000 TO 1556757600000]

.

Date Math Syntax:

Date math expressions consist of 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 p.m. (

NOW

), then

NOW/HOUR

would be the start of that hour, 4:00 p.m. Valid values in date math are:

Date Math Range:

Date math supports date range searches. The syntax is

[startDate TO endDate}

.

A square bracket (

[

) indicates that the date is included in the range; a curly bracket (

}

) indicates that the date is excluded.

For example, to search 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.