All Collections
Using quintly
Using dynamic dates
Using dynamic dates
Lukas Nordbeck avatar
Written by Lukas Nordbeck
Updated over a week ago

What are dynamic dates?

In contrast to a static date period (e.g. June 1, 2017 to June 30, 2017) a dynamic date is relative to the current time. Dynamic dates 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.

  • Today or Now Selects today as a one day time period.

  • Yesterday Selects yesterday as a one day time period.

  • 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"

  • Previous[ <number>] week(s)/month(s) Selects a time period covering the previous full weeks/months.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"

  • <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"

  • [Last ]<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", "jan 2015 to yesterday", "jan to now", "Last April", "Last Mar", "Last April to October", "Last jan to dec", "Apr to Dec"

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. All terms are case insensitive, e.g. "today" or "Today" won't make a difference.

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.

Did this answer your question?