Get Free Trial
API reference
Table of contents

DateQueryObject

Conditional filter to apply to the date hierarchies (except "date" type for CSV/JSON that creates separate hierarchies for years, months and days). Accepts dates in "YYYY-MM-DD" format. Here is a list of all available conditions:

  • equal – String. Equal to some date. Example: { "equal": "2018-12-31" }.
  • not_equal – String. Not equal to some date. Example: { "not_equal": "2018-12-31" }.
  • before – String. Before some date. Example: { "before": "2018-12-31" }.
  • before_equal – String. Before or equal to some date. Example: { "before_equal": "2018-12-31" }.
  • after – String. After some date. Example: { "after": "2018-12-31" }.
  • after_equal – String. After or equal to some date. Example: { "after_equal": "2018-12-31" }.
  • between – Array of strings. Between two dates (including them). Example: { "between": ["2018-12-31", "2018-12-31"] }.
  • not_between – Array of strings. Not between two dates (excluding them). Example: { "not_between": ["2018-12-31", "2018-12-31"] }.
  • last – String. Filter dates of some previous period. Possible values: "day", "week", "month", "quarter", "year". Example: { "last": "week" }.
  • current – String. Filter dates of some current period. Possible values: "day", "week", "month", "quarter", "year". Example: { "current": "week" }.
  • next – String. Filter dates of some next period. Possible values: "day", "week", "month", "quarter", "year". Example: { "next": "week" }.