Adaptive Search Queries: Date Buckets

Adaptive search supports te following data buckets for date-based search.

Date Bucket Name Mnemonic Calendar Type JSON Sample

Today

Today

Day

"q": {                 "op": "$eq",                 "attribute": "CreationDate",                 "value": "now"             }

Over 2 Years Ago

Over2YearsAgo

Year

 

Last 90 days

Last90days

Day

"q": {
                "op": "$lt",
                "attribute": "CreationDate",
                "value": "now-90d/d"
            }

Next Year

NextYear

Year

 

This Year

ThisYear

"q": {
                "op": "$wi",
                "attribute": "DueDate",
                "value1":"2019-01-01",
                "value2": "2019-12-31"
            }

Next 90 days

Next90days

Day

"q": { "op": "$wi", "attribute": "DueDate", "value1":"now", "value2": "now+90d/d" }

Last Year

LastYear

Year

 

Next 9 Months

Next9Months

Month

    "q": {
                "op": "$lt",
                "attribute": "CreationDate",
                "value": "now-9M/M"
            }

Last 60 days

Last60days

Day

 

This Month

ThisMonth

Month

 

Last 3 Months

Last3Months

Month

 

Tomorrow

Tomorrow

Day

 

Last 9 Months

Last9Months

Month

 

This Quarter

ThisQuarter

Quarter

 

Over 3 Years Ago

Over3YearsAgo

Year

 

Next Month

NextMonth

Month

 

First Month Of This Quarter

FirstMonthOfThisQuarter

Quarter

 

Next 3 Months

Next3Months

Month

 

This Week

ThisWeek

CalendarWeek

 

In The Future

InTheFuture

Day

 

Last Month

LastMonth

Month

 

Last 30 days

Last30days

Day

 

Over 1 Year Ago

Over1YearAgo

Year

 

Next Quarter

NextQuarter

Quarter

 

Last Week

LastWeek

CalendarWeek

 

Yesterday

Yesterday

Day

 

Next 30 days

Next30days

Day

 

Next 60 days

Next60days

Day

 

Next 6 Months

Next6Months

Month

 

Next Week

NextWeek

CalendarWeek

 

First 2 Months Of This Quarter

First2MonthsOfThisQuarter

Quarter

 

Last Quarter

LastQuarter

Quarter

 

Last 6 Months

Last6Months

Month

 

In The Past

InThePast

Day

 

This Fiscal Quarter

ThisFiscalQuarter

Fiscal Quarter

   "q": {
                "op": "$wi",
                "attribute": "CreationDate",
                "value1": "now/fq",
                "value2": "now/fq+1fq"
            }