Skip to main content
Browse Documentation
Relative time period

ZenQL search – relative time period

Created by r.saunders, last modified by r.bromley on 13 Feb 2022

A relative time period is a token that can convert a date and time value, relative to the current date and time (UTC). It can be used in an operator or as a parameter of a date time function.

Syntax

The token consists of 1 or more space-delimited segments and can optionally contain a preceding plus or minus sign. The sign can only be used once and is applied to the whole expression. When combining segments, there is no need enclose them in double quotes.

<token>:=
    [- | +]<segment>[ <segment> ...n]

<segment>:=
    <int>y|M|w|d|h|m

Supported relative periods
Period Syntax Example
Year {int}y 1y
Month {int}M 2M
Week {int}w 2w
Day {int}d 5d
Hour {int}h 10h
Minute {int}m 15m

Examples

  • Show all items that have been created in the last 24 hours.
    sys.version.created >= -1d
  • Used stand-alone to list records created in the last month plus 1 week.
    sys.version.created >= -1M 1w
  • Used as a parameter to an Expression Function to list records created last year. The year is inferred by the date function.
    sys.version.created >= startOfYear(-1) and <= endOfYear(-1)