Relative time
Usenow by itself or add and subtract an interval:
Relative values are resolved when the query is compiled.
Fixed dates and timestamps
Use an ISO date when whole-day meaning is useful:tls.not_after<=2026-08-01 includes the whole of 1 August 2026 UTC.
Use RFC 3339 for an exact point in time:
YYYY-MM-DD HH:MM:SS where the field policy allows a
timestamp.
Range literals
Square brackets include a boundary. Curly braces exclude it:* for an open boundary:
[* TO *] is an existence query.
Range literals use the
: operator. Use comparison operators for a single
bound, such as timestamp>=now-24h.Observation fields
Choose the field whose clock matches the question:
The exact field name depends on the dataset. Browse the
Data Dictionary before using time logic in automation.