Finding records relative to today's date

You can write Quick Base 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

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:

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

Operator Description

the previous n days

Starts at 12:00:00 a.m. n days before the current day and continues to the end of yesterday. (The range does not include the current day.)

the next n days

Starts at 12:00:00 a.m. tomorrow and continues for n days. (The range does not include the current day.)

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, Quick Base uses the default of 12:00:00 a.m. on Sunday and continues for 7 complete days (ending at 11:59:59 on Saturday.)

Operator Description

The current week

Starts at 12:00:00 a.m. on the first day of the current week and continues for seven days.

the next n weeks

Starts at 12:00:00 a.m. on the first day of next week and continues for the next n weeks. (The range does not include the current week.)

the previous n weeks

Starts at 12:00:00 a.m. n weeks before the current week and continues for n weeks. (The range does not include the current week.)

Relative months

In Quick Base, 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.)

Operator Description

the current month

Starts at 12:00:00 a.m. on the first day of the current month and continues until 11:59:59 on the last day of the month.

the next n months

 

Starts at 12:00:00 a.m. on first day of the next month and continues for n months. (The range does not include the current month.)

the previous n months

Starts at 12:00:00 a.m. n months before the current month and continues for n months. (The range does not include the current month.)

Relative quarters

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

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

Operator Description

the current quarter

Starts at 12:00:00 a.m. on the first day of the current quarter and continues for three months, ending at 11:59:59 on the last day of the quarter.

the next n quarters

Starts at 12:00:00 a.m. on first day of the quarter immediately following the current quarter and continues for n quarters. (The range does not include the current quarter.)

the previous n quarters

Starts at 12:00:00 a.m. n quarters before the current quarter and continues for n quarters. (The range does not include the current quarter.)

Relative fiscal quarters

Fiscal year definitions vary from organization to organization. For each Quick Base 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.

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

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

Operator Description

the current fiscal year

Starts at 12:00:00 a.m. on the first day of the current fiscal quarter and continues for three months, ending at 11:59:59 on the last day of the third month.

the next n fiscal quarters

Starts at 12:00:00 a.m. on first day of next fiscal quarter and continues for n fiscal quarters. (The range does not include the current fiscal quarter.)

the last n fiscal quarters

Starts at 12:00:00 a.m. n quarters before the current fiscal quarter and continues for n fiscal quarters. (The range does not include the current fiscal quarter.)

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.

Operator Description

the current year

Starts at 12:00:00 a.m. January 1st of the current year and continues for 12 months (through December 31.

the next n years

Starts at 12:00:00 a.m. on January 1st of the year immediately following the current year and continues for n years. (The range does not include the current year.)

the previous n years

Starts at 12:00:00 a.m. n years before the current year and continues for n years. (The range does not include the current year.)

Relative fiscal years

Fiscal year definitions vary from organization to organization. For each Quick Base 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, Quick Base uses the January as the default.

Operator Description

the current fiscal year

Starts at 12:00:00 a.m. on the first day of the current year and continues for 12 months.

the next n fiscal years

Starts at 12:00:00 a.m. on the start date of next fiscal year and continues for n years. (The range does not include the current fiscal year.)

the last n fiscal years

Starts at 12:00:00 a.m. n fiscal years before the current fiscal year and continues for n fiscal years. (The range does not include the current fiscal year.)

Related Topics:

 

Go back      |       |   

© 1999-2018  QuickBase, Inc.  All rights reserved.  Legal Notices.