Relative Date Filter Reference

For example, instead of filtering on Close Date greater than Jan 1, 2017, filter using a relative date: Close Date equals this year.

For Enterprise, Unlimited, Performance, Professional, and Developer Editions, the week is defined by the Locale dropdown list on your personal information page. For Contact Manager, Group, and Personal Editions, the week is defined by the Locale setting in the company profile. For example, when the locale is US English, a week runs Sunday to Saturday, whereas with UK English, a week spans Monday to Sunday.

Capitalization doesn't matter in relative date filter operators. THIS YEAR works, as do This Year and this year.

• 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 opportunity report's standard date filter is CLOSE DATE equals NEXT 5 DAYS and you run it on October 24. The report returns opportunities that close sometime between October 24 through October 28.

  Say that your opportunity report has a custom field filter (instead of a standard date filter) for CLOSE DATE equals NEXT 5 DAYS and you run it on October 24. The report returns opportunities that close sometime between October 25 through October 29.

• The drill down option for reports in Lightning Experience 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.