Relative Date Filter Reference
Apr 09, 2024
Relative date filters let you filter on date fields using easy-to-understand, human-speech-inspired syntax.
For example, instead of filtering on Close Date greater than Jan 1, 2020, filter using a relative date: Close Date equals this year.
Capitalization doesn't matter in relative date filter operators. THIS YEAR works, as do This Year and this year.
Notes:
- Standard filters and custom field filters interpret relative date filters that begin with NEXT n DAYS - differently. Standard date filters return records that are time-stamped on the day that the report is run continuing for n days. Custom field filters return records time-stamped on the day after the day the report is run continuing for n days.
For example, say that your Relationship report's standard date filter is END DATE equals NEXT 5 DAYS and you run it on October 24. The report returns Relationships that close sometime between October 24 through October 28.
Say that your Relationship report has a custom field filter (instead of a standard date filter) for END DATE equals NEXT 5 DAYS and you run it on October 24. The report returns Relationships with end dates sometime between October 25 through October 29.
- The drill down option for reports in works only if the date field is grouped by any of the options available in the list of relative date filters in the following table. For example, if the date field on the report is grouped by Fiscal Period or Fiscal Week, you cannot drill down in the report.
- Time periods "Start at 12:00:00 AM" = @
| RELATIVE DATE VALUE | RANGE |
|---|---|
| YESTERDAY | @ on the day before the current day and continues for 24 hours. |
| TODAY | @ on the current day and continues for 24 hours. |
| TOMORROW | @ on the day after the current day and continues for 24 hours. |
| LAST WEEK | @ on the first day of the week before the current week and continues for seven days. |
| THIS WEEK | @ on the first day of the current week and continues for seven days. |
| NEXT WEEK | @ on the first day of the week after the current week and continues for seven days. |
| LAST n WEEKS | @ on the first day of the week that started n weeks before the current week, and continues up to 11:59 PM on the last day of the week before the current week. |
| NEXT n WEEKS | @ on the first day of the week after the current week and continues for n times seven days. |
| n WEEKS AGO | @ on the first day of the week that started n weeks before the start of the current week and continues for seven days. |
| LAST MONTH | @ on the first day of the month before the current month and continues for all the days of that month. |
| THIS MONTH | @ on the first day of the current month and continues for all the days of that month. |
| NEXT n MONTHS | @ on the first day of the month after the current month and continues until the end of the nth month. |
| LAST n MONTHS | @ on the first day of the month that started n months before the current month and continues up to 11:59 PM on the last day of the month before the current month. |
| n MONTHS AGO | @ on the first day of the month that started n months before the start of the current month and continues for all the days of that month. |
| NEXT MONTH | @ on the first day of the month after the current month and continues for all the days of that month. |
| LAST n DAYS | @ n days before the current day and continues up to the current second. (The range includes today. Using this date value includes records from n + 1 days ago up to the current day.) In standard filters, n can be 7, 30, 60, 90, or 120. |
| NEXT n DAYS |
For standard date filters, @ on the day that the report is run and continues for n days. (The range includes today.) In standard filters, n can be 7, 30, 60, 90, or 120. For custom field filters, starts at 12:00:00 AM on the next day and continues for the next n days. (The range does not include today.) |
| n DAYS AGO | @ on the day n days before the current day and continues for 24 hours. (The range does not include today.) |
| LAST QUARTER | @ on the first day of the calendar quarter before the current calendar quarter and continues to the end of that quarter. |
| THIS QUARTER | @ on the first day of the current calendar quarter and continues to the end of the quarter. |
| NEXT QUARTER | @ on the first day of the calendar quarter after the current calendar quarter and continues to the end of that quarter. |
| LAST n QUARTERS | @ on the first day of the calendar quarter n quarters ago and continues to the end of the calendar quarter before the current quarter. (The range does not include the current quarter.) |
| NEXT n QUARTERS | @ on the first day of the calendar quarter after the current quarter and continues to the end of the calendar quarter n quarters in the future. (The range does not include the current quarter.) |
| n QUARTERS AGO | @ on the first day of the calendar quarter n quarters before the current calendar quarter and continues to the end of that quarter. |
| LAST YEAR | @ on January 1 of the year before the current year and continues through the end of December 31 of that year. |
| THIS YEAR | @ on January 1 of the current year and continues through the end of December 31 of the current year. |
| NEXT YEAR | @ on January 1 of the year after the current year and continues through the end of December 31 of that year. |
| n YEARS AGO | @ on January 1 of the calendar year n years before the current calendar year and continues through the end of December 31 of that year. |
| LAST n YEARS | @ on January 1, n+1 years ago. The range ends on December 31 of the year before the current year. |
| NEXT n YEARS | @ on January 1 of the year after the current year and continues through the end of December 31 of the nth year. |
| LAST FISCAL QUARTER |
@ on the first day of the fiscal quarter before the current fiscal quarter and continues through the last day of that fiscal quarter. The fiscal quarter is defined on the Fiscal Year page in Setup.
NOTE None of the FISCAL literal date values are supported when creating mobile custom views. |
| THIS FISCAL QUARTER | @ on the first day of the current fiscal quarter and continues through the end of the last day of the current fiscal quarter. The fiscal quarter is defined on the Fiscal Year page in Setup. |
| NEXT FISCAL QUARTER | @ on the first day of the fiscal quarter after the current fiscal quarter and continues through the last day of that fiscal quarter. (The range does not include the current quarter.) The fiscal quarter is defined on the Fiscal Year page in Setup. |
| LAST n FISCAL QUARTERS | @ on the first day of the fiscal quarter n fiscal quarters ago and continues through the end of the last day of the previous fiscal quarter. (The range does not include the current fiscal quarter.) The fiscal quarter is defined on the Fiscal Year page in Setup. |
| NEXT n FISCAL QUARTERS | @ on the first day of the fiscal quarter after the current fiscal quarter and continues through the end of the last day of the nth fiscal quarter. (The range does not include the current fiscal quarter.) The fiscal quarter is defined on the Fiscal Year page in Setup. |
| n FISCAL QUARTERS AGO | @ on the first day of the fiscal quarter n fiscal quarters before the current fiscal quarter and continues through the end of the last day of that fiscal quarter. |
| LAST FISCAL YEAR | @ on the first day of the fiscal year before the current fiscal year and continues through the end of the last day of that fiscal year. The fiscal quarter is defined on the Fiscal Year page in Setup. |
| THIS FISCAL YEAR | @ on the first day of the current fiscal year and continues through the end of the last day of the fiscal year. The fiscal quarter is defined on the Fiscal Year page in Setup. |
| NEXT FISCAL YEAR | @ on the first day of the fiscal year after the current fiscal year and continues through the end of the last day of that fiscal year. The fiscal quarter is defined on the Fiscal Year page in Setup. |
| LAST n FISCAL YEARS | @ on the first day of the fiscal year n fiscal years ago and continues through the end of the last day of the fiscal year before the current fiscal year. (The range does not include the current fiscal year.) The fiscal quarter is defined on the Fiscal Year page in Setup. |
| NEXT n FISCAL YEARS | @ on the first day of the fiscal year after the current fiscal year and continues through the end of the last day of the nth fiscal year. (The range does not include the current fiscal year.) The fiscal quarter is defined on the Fiscal Year page in Setup. |
| n FISCAL YEARS AGO | @ on the first day of the fiscal year n fiscal years ago and continues through the end of the last day of that fiscal year. |
