Filter Options for Date Fields
When you define a query and include date fields as filters, you select criteria operators such as "Is," "Before," or "After," and then the date filter options to use. For example, to create a query of records added the previous week, you select Date added "Is" "Last week."
The following tables provide detail about each date filter option that is available.
Days
A day starts at 12:00:00 a.m. and continues until 11:59:59 p.m. Start and end times use the database server's time zone.
|
Option |
Description |
| Specific date | Starts at 12:00:00 a.m. on the day you specify and continues for 24 hours. |
| Today | Starts at 12:00:00 a.m. on the current day and continues for 24 hours. |
| Yesterday | Starts at 12:00:00 a.m. on the day before the current day and continues for 24 hours. |
| Tomorrow | Starts at 12:00:00 a.m. on the day after the current day and continues for 24 hours. |
Weeks
A week starts at 12:00:00 a.m. on Sunday and continues for seven consecutive days until 11:59:59 p.m. on the seventh day. Start and end times use the database server's time zone.
|
Option |
Description |
| This week | Starts at 12:00:00 a.m. on the Sunday of the current week and continues for seven days. |
|
Last week |
Starts at 12:00:00 a.m. on the Sunday of the week before the current week and continues for seven days. |
| Next week | Starts at 12:00:00 a.m. on the Sunday of the week after the current week and continues for seven days. |
Months
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 use the database server's time zone.
|
Option |
Description |
| This month | Starts at 12:00:00 a.m. on the first day of the current month and continues for all the days in the month. |
| Last month | Starts at 12:00:00 a.m. on the first day of the month before the current month and continues for all the days in that month. |
| Next month | Starts at 12:00:00 a.m. on the first day of the month after the current month and continues for all the days in that month. |
| Month to date | Starts at 12:00:00 a.m. on the first day of the current month and continues to the current date. |
Quarters
Each year is divided into four, three month long calendar quarters. The program uses the following quarter definitions:
-
First quarter - January through March
-
Second quarter - April through June
-
Third quarter - July through September
-
Fourth quarter - October through December
|
Option |
Description |
| This quarter | Starts at 12:00:00 a.m. on the first day of the current calendar quarter and continues to the end of the quarter. |
| Last quarter | Starts at 12:00:00 a.m. on the first day of the calendar quarter before the current calendar quarter and continues to the end of that quarter. |
| Next quarter | Starts at 12:00:00 a.m. on the first day of the calendar quarter after the current calendar quarter and continues to the end of that quarter. |
| Quarter to date | Starts at 12:00:00 a.m. on the first day of the current quarter and continues to the current date. |
Years
A year is the 12 month time period that begins at 12:00:00 a.m. on January 1st and ends at 11:59:59 p.m. on December 31st.
|
Option |
Description |
| This calendar year | Starts at 12:00:00 a.m. on January 1st of the current year and continues for 365 days. |
| Last calendar year | Starts at 12:00:00 a.m. on January 1st of the year before the current year and continues for 365 days. |
| Next calendar year | Starts at 12:00:00 a.m. on January 1st of the year after the current year and continues for 365 days. |
| Calendar YTD | Starts at 12:00:00 a.m. on January 1st of the current year and continues to the current date. |