Relative Date Syntax

Using NLP, matches operator can smartly translate the text you input to a time range. Usually it works in the Date Filter.

Matches

Using NLP, matches operator can smartly translate the text you input to a time range. Do note that the matches operator resolves condition values at runtime, not when saving the report.

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.

Format	Description	Example
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
beginning	This equal to “1970-01-01” which is the earliest day for our system

Date / Time range

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

Format	Description	Example
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.