Home

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 2018

evaluatedOn: [2018-01-01 .. 2018-04-01]

evaluatedOn: [2018-02-01 ... 2018-04-01]

 

Find resources evaluated between 10 days ago and 1 second ago

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

Find resources evaluated on February 1st 2018

evaluatedOn: '2018-02-01'

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

evaluatedOn: "2018-02-01 10:53:49"

Date variables

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

We support:

yyyy (i.e. 2018)

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

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

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

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

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

Use the "now" shortcut

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

Comparison operators

We support comparison operators in your date searches.

created > 2018-03-12

created >= 2018-03-12

created < 2018-03-12

created <= 2018-03-12