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.)

In this topic:

• The is during operator

• Relative days

• Relative weeks

• Relative months

• Relative quarters

• Relative fiscal quarters

• Relative years

• Relative fiscal years

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.

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.

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.)

If your application manager does not set a specific first day of the week, Quickbase uses the default of 12:00:00 a.m. on Sunday and continues for 7 complete days (ending at 11:59:59 on Saturday.)

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. (Start and end times are always based on the application's time zone.)

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

Note: Each application manager can also define when fiscal quarters start.  Learn more about fiscal quarters.

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. You define the start month of your fiscal year; the fiscal year continues for 12 months following the start month.

Quickbase automatically calculates your fiscal quarters based on the fiscal year start month.

If your application manager does not set the fiscal year, Quickbase uses the calendar year and calendar quarters as the default.

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. The fiscal year continues for 12 months following the start month. The fiscal year ends at 11:59:59 on the last day of the 12th month.

If your application manager does not define your fiscal year starting month, Quickbase uses the January as the default.

Related topics:

• Filter Records

• Sorting/Grouping

• Columns to Display

• About Row Colorization