What are dynamic dates?
In contrast to a static date period (e.g. June 1, 2017 to June 30, 2017) the dynamic date is always relative to the current time. This allows you to select a more intelligent date.
Dynamic dates also come in handy for automatic reports that are scheduled on a regular basis. This way you don't have to go into the report set up and manually change the dates each time your report is sent or downloaded.
You can locate the smart search in the date selector at the top right hand corner. Below you find a full list of formats it can handle so you can start playing around with it.
- Last[ <number>] day(s)/week(s)/month(s)/year(s),
- Selects a time period using yesterday as the end date. Excluding the current day is on purpose to skip unfinished days for analysis. Use the "-<number> <period>, +<number> <period>" selector to build a relative time period including today.
- E.g. "Last 3 days", "Last 2 months", "Last week", "Last month"
- Last <month-from>[ to <month-until>]
- Selects a time period 1st of <month-from> to last day of <month-until>. If the second part is missing, <month-until> is considered to be the same as <month-from>.
- E.g. "Last April", "Last Mar", "Last April to October", "Last jan to dec", "Apr to Dec"
- Previous week/month
- Selects a time period covering the previous full week/month.
- E.g. assuming today is a Wednesday, "previous week" will select the full week before Monday to Sunday. Assuming today is the 10th of April, "previous month" will select 1st to 31th of March.
- This week/month/quarter/year
- Selects a time period from beginning of this week/month/quarter/year to the end of this week/month/quarter/year, including today.
- E.g. "This year", "This quarter"
- -<number> day(s)/week(s)/month(s)/year(s), +<number> day(s)/week(s)/month(s)/year(s)
- Selects a time period, setting the start by evaluating the first part of this selector, setting the end by evaluating the second part. This is one of the most powerful selectors as it can select time periods not ending in yesterday or today.
- E.g. "-0 days, +0 days" is selecting today, "-7 days, +6 days" matches "last week" or "last 7 days"
There are two more formats our date selectors understands, but are technically speaking not dynamic dates as they describe a static date period. Still those can sometimes be handy to select a date period quicker using the smart search.
- <date-from>[ to <date-until>]
- Selects a time period from <date-from> to <date-until>. Dates need to be in "YYYY-MM-DD" format, e.g. "2020-03-01". If the second part is missing, <date-until> is considered to be the same as <date-from>. Precisely of course this is not a relative time period, it is static.
- E.g. "2020-03-01", "2020-01-01 to 2020-02-29"
- <month-and-year-from>[ to <month-and-year-until>]
- Selects a time period 1st of <month-and-year-from> to last day of <month-and-year-until>. If the second part is missing, <month-and-year-until> is considered to be the same as <month-and-year-from>.
- E.g. "April 2019 to Mar 2020", "jan 2018 to mar"
Parts in square brackets [...] are optional. Month names can be used in both short and long form (e.g. "Mar" and "March") in English language.
Use any of the examples above, put it into the input box top right within the date selector, and press ENTER. You will immediately see the dates change in the calendar. This way you can easily test your specific dynamic date.
Anywhere in our tool where the date selector is being used, e.g. within the report settings, these are valid inputs.