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