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 assets with patches installed between 1-2 months ago

installedDate: [now-2M .. now-1M]

Find assets with patches installed between January 1st and April 1st 2018

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

Find assets with patches installed between 10 days ago and 1 second ago

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

Find assets with patches installed between 2018-10-01 and 2018-10-03

installedDate: [2018-10-01 .. 2018-10-03]

Find assets with patches installed on November 1st 2018

installedDate: '2018-11-01'

Find assets with patches installed on November 1st 2018 at time 10:53:49

installedDate: "2018-11-01 10:53:49"

Date variables

Date variables help you define a date or date range you're interested in. We support yyyy, yyyy-MM, yyyy-MM-dd and more.

Find assets with deployment job started between January 1st 2018 and December 31st 2018 (i.e. yyyy)

startDateTime: "2018"

Find assets with deployment job started between November 1st and 30th 2018 (i.e. yyyy-MM)

startDateTime: "2018-11"

Find assets with deployment job started anytime on November 1st 2018 (i.e. yyyy-MM-dd)

startDateTime: "2018-11-01"

Find assets with deployment job started on November 1st 2018 from 10 to 11am (i.e. yyyy-MM-dd HH)

startDateTime: "2018-11-01 10"

Find assets with deployment job started on November 1st 2018 at 10:15am (i.e. yyyy-MM-dd HH:mm)

startDateTime: "2018-11-01 10:15"

Find assets with deployment job started on November 1st 2018 at 10:15:44am (i.e. yyyy-MM-dd HH:mm:ss)

startDateTime: "2018-11-01 10:15:44"

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.

endDateTime > 2018-10-12

endDateTime >= 2018-10-12

endDateTime < 2018-10-12

endDateTime <= 2018-10-12

 

Step by step search tutorial