Date Filters

What is Date Filter?

Date Filter is one of the manual-input filter types that can create filtering conditions on time-base fields. For example:

  • To see revenue on a specific date
  • To see user growth in the last 3 weeks

Date Filter can be applied to fields of Date and Datetime data type.

Date Operators

  • last, next: when selecting these operators, you can also choose a modifier to specify the time unit (day, week, month, year)
  • between
  • before
  • after
  • is on
  • is null
  • is not null

Matches

Using NLP, matches operator can smartly translate the text you input to a time range.

Examples of valid syntax:

  • yesterday
  • monday last week
  • last 2 months
  • 3 weeks ago till today
  • next 3 years in the future
  • 19:00 yesterday to now
  • Dec 2018 - 1/1/2020
  • 1998 - 2018

Exact date

Both absolute and relative date values are acceptable.

FormatDescriptionExample

DD MMM YYYY, MMM DD YYYY

01 April 2020, April 01 2020

DD-MM-YYYY, YYYY-MM-DD

01-04-2020, 2020-04-01

DD/MM/YYYY, YYYY/MM/DD

01/04/2020, 2020/04/01

today, yesterday, tomorrow

[weekday] this week

monday this week, wed this week

[weekday] next/last x week(s)

tuesday last 2 weeks, fri last 3 weeks

[time period] begin/end

The first/last day of the time period. Time period can include: - this year/ month/ week - last x year(s)/ month(s)/ week(s) - next x year(s)/ month(s)/ week(s)

Today is Mar 15, 2020.last month begin will translate to Feb 01, 2020.

x day(s) ago

1 day ago, 2 days ago

Date / Time range

Note: We only support Date Range at the moment, please leave us a note if Time range is critical to you.

FormatDescriptionExample

MMM YYYY

Cover all dates in a month.

April 2020, Mar 2020

YYYY

Cover all dates in a year.

2019, 2020

[start date] -/to [end date]

Cover all dates in range, including end date. [date] accepts both absolute and relative values. Note: there must be spaces around the hyphen

2020-03-01 to 2020-04-01, last month end - today

[start date] till/until [end date]

Cover all dates in range, excluding end date.

2020-03-01 till 2020-04-01, last month end until today

last x year(s)/ month(s)/ week(s)/ day(s)

Cover all dates in the previous x units, except the current year/ month/ week/ date.

Today is Mar 15 2020. last 2 years covers 2018 and 2019, last 2 months covers Jan and Feb 2020

x year(s)/ month(s) /week(s) ago

Cover all dates in a single year/month/week at x units before the current time.

Today is Mar 15 2020. 2 months ago covers the whole January 2020, 2 years ago covers 2018.

this year/month/week

Cover all dates within the same year/month/week with the current time.

Today is Mar 15 2020. this month covers the whole March 2020, this year covers 2020.

next x year(s)/ month(s)/ week(s)/ day(s)

Cover all dates in the next x units, except the current year/month/week/date

Today is Mar 15 2020. next 2 years cover 2021 and 2022, next 2 days cover Mar 16 and 17.