How to enter dates in your queries

To search for dates you'll use a date range [start date .. end date] or a specific date.

Examples

Find resources evaluated between January 1st and April 1st 2020

createdOn: [2020-01-01 .. 2020-04-01]

createdOn: [2020-02-01 ... 2020-04-01]

Find resources evaluated between 10 days ago and 1 second ago

createdOn: [now-10d .. now-1s]

Find resources evaluated on February 1st 2020

createdOn: '2020-02-01'

Find resources evaluated on February 1st 2020 at time 10:53:49am

createdOn: "2020-02-01 10:53:49"

Date variables help you define a date or date range you're interested in.

We support:

yyyy (i.e. 2020)

yyyy-MM (i.e. 2020-02)

yyyy-MM-dd (i.e. 2020-02-15)

yyyy-MM-dd HH (i.e. 2020-02-15 10 for Feb 15 from 10am-11am)

yyyy-MM-dd HH:mm (i.e. 2020-02-15 10:30 for Feb 15 at 10:30am)

yyyy-MM-dd HH:mm:ss (i.e. 2020-02-15 10:30:44 for Feb 15 at 10:30:44am)

Type now- then a number and a time unit: y (year), M (month), w (week), d (day), h (hour), m (minute), s (second)

now-1y for 1 year ago

now-2M for 2 months ago

now-5d for 5 days ago

We support comparison operators in your date searches.

created > 2020-03-12

created >= 2020-03-12

created < 2020-03-12

created <= 2020-03-12