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
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)
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 > 2020-03-12
created >= 2020-03-12
created < 2020-03-12
created <= 2020-03-12