Skip to main content

Time Frames


Time period descriptors in Indicate represent either rolling windows or calendar-based intervals:

  • A rolling window is dynamic and relative to the current date. For example, last7days refers to the seven full days before today and updates daily.
  • A calendar-based interval aligns with fixed calendar units like a full week, month, or year.

The exact behavior of each descriptor depends on its periodicity, which defines how boundaries are calculated, including whether the current day is part of the interval.

Learn more about how periodicity works in → Periodicity.

Reference Date

All examples on this page assume the current date is May 15, 2025.


Simple Day Descriptors

QueryLabelExample
todayTodayThe current day. Example: May 15, 2025.
yesterdayYesterdayThe previous day. Example: May 14, 2025.
tomorrowTomorrowThe next day. Example: May 16, 2025.

To-Date Periods

QueryLabelExample
weekToDateWeek to DateExample: May 12–15, 2025.
monthToDateMonth to DateExample: May 1–15, 2025.
quarterToDateQuarter to DateExample: Apr 1–May 15, 2025.
yearToDateYear to DateExample: Jan 1–May 15, 2025.

Rolling Past Periods

QueryLabelExample
last7daysLast 7 DaysExample: May 8–14, 2025
last14daysLast 14 DaysExample: May 1–14, 2025
last28daysLast 28 DaysExample: Apr 17–May 14, 2025
last30daysLast 30 DaysExample: Apr 15–May 14, 2025
last60daysLast 60 DaysExample: Mar 16–May 14, 2025
last90daysLast 90 DaysExample: Feb 14–May 14, 2025
last365daysLast 365 DaysExample: May 15, 2024–May 14, 2025

Rolling Future Periods

QueryLabelExample
next7daysNext 7 DaysExample: May 16–22, 2025
next14daysNext 14 DaysExample: May 16–29, 2025
next28daysNext 28 DaysExample: May 16–June 12, 2025
next30daysNext 30 DaysExample: May 16–June 14, 2025
next60daysNext 60 DaysExample: May 16–July 14, 2025
next90daysNext 90 DaysExample: May 16–Aug 13, 2025
next365daysNext 365 DaysExample: May 16, 2025–May 15, 2026

Calendar-Based Periods

QueryLabelExample
thisWeekThis WeekExample: May 12–18, 2025
thisMonthThis MonthExample: May 1–31, 2025
thisQuarterThis QuarterExample: Apr 1–June 30, 2025
thisYearThis YearExample: Jan 1–Dec 31, 2025
lastWeekLast WeekExample: May 5–11, 2025
lastMonthLast MonthExample: Apr 1–30, 2025
lastQuarterLast QuarterExample: Jan 1–Mar 31, 2025
lastYearLast YearExample: Jan 1–Dec 31, 2024
nextWeekNext WeekExample: May 19–25, 2025
nextMonthNext MonthExample: June 1–30, 2025
nextQuarterNext QuarterExample: July 1–Sept 30, 2025
nextYearNext YearExample: Jan 1–Dec 31, 2026