Salesforce Relative Date Values allow you to easy query data within List Views and Reports based on convenient rolling date ranges like "Last 30 Days" or "Last 2 Months." When using Relative Date Values it is important to understand their definitions.
For Example, "This week" is defined by the Locale dropdown list on your personal information page. For example, when the Locale setting is US English, a calendar week runs Sunday through Saturday, whereas with UK English, a week spans Monday through Sunday.
Relative date filters let you filter on date fields using easy-to-understand, human-speech-inspired syntax.
For example, instead of filtering on Sold On date greater than Jan 1, 2021
, filter using a relative date of: Sold On date equals THIS YEAR
.
Capitalization doesn't matter in relative date filter operators. THIS YEAR works, as do This Year and this year.
For all Salesforce Relative Date values and their definitions, see:
https://help.salesforce.com/s/articleView?id=sf.filter_dates_relative.htm&type=5