---
title: "Finding Records Relative to Today's Date"
slug: "finding-records-relative-to-todays-date"
updated: 2026-06-01T15:37:00Z
published: 2026-06-01T15:37:00Z
canonical: "help.quickbase.com/finding-records-relative-to-todays-date"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.quickbase.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Finding Records Relative to Today's Date

You can create Quickbase reports to find records where certain dates fall within relative date ranges. A relative date range is a period of time that is relative to the current date. (Last Week, Next Month, and During the Next 3 Quarters are examples of relative date ranges.)

## The **is during** operator

Using relative date ranges allows you to create reports that you can run periodically without needing to alter your report. For example, each month, you may want to run a report that shows all tasks with completion dates that occurred during the last month. You can write a report using the **Is during** operator to find all records where the completion date field falls within the relative date range of Last Month.

You can also use the **Is not during** operator to find records with dates that**do not** fall within the specified dynamic date range.

![Screenshot of the Is during operator in a Quickbase report filter, showing relative date range options](https://cdn.document360.io/dd260e4e-10bb-4b66-8fb3-5504c272b904/Images/Documentation/relative.png)

Use the **Is during** operator and specify a matching value to build reports that use relative date ranges in the following categories:

- Days
- Weeks
- Months
- Quarters
- Fiscal Quarters
- Years
- Fiscal Years

(You can also use the **Is not during** operator to find records with dates that do not fall within the specified relative date range.)

## Relative days

A day starts at 12:00:00 a.m. and continues for 24 hours, ending at 11:59:59 p.m. (Start and end times are always based on the account's time zone.)

## Relative weeks

Each application manager can [define the first day of the week](/v1/docs/setting-calendar-options-for-apps).

A week starts at 12:00:00 a.m. on the specified start day and continues 7 consecutive days, ending at 11:59:59 p.m. on the seventh day. (Start and end times are always based on the [application's time zone](/v1/docs/set-the-time-zone-for-both-the-application-and-the-account).)

## Relative months

In Quickbase, months are defined according to the Western calendar. A month starts at 12:00:00 a.m. on the first day of a month and continues until 11:59:59 p.m. on the last day of the month.

## Relative quarters

Each year is divided into four 3-month long calendar quarters. In Quickbase, calendar quarters are defined as follows:

- Q1—January through March
- Q2—April through June
- Q3—July through September
- Q4—October through December

## Relative fiscal quarters

Fiscal year definitions vary from organization to organization. For each Quickbase application, application managers can [define the fiscal year your company uses](/v1/docs/setting-calendar-options-for-apps).

## Relative years

A year is the 12-month time period beginning at 12:00:00 a.m. on January 1st and ending at 11:59:59 on December 31st.

## Relative fiscal years

Fiscal year definitions vary from organization to organization. For each Quickbase application, application managers can [define the month on which your fiscal year starts](/v1/docs/setting-calendar-options-for-apps). The fiscal year continues for 12 months following the start month.