Loading

Salesforce Reports: Range vs. Relative Date Filters for Date Fields

게시 일자: Jun 22, 2026
상세 설명

When adding date field filters to Salesforce reports, two types of date filtering are available depending on which field is being filtered. The primary (default) date range filter supports a 'Range' dropdown with preset values such as 'This Month', 'Last Quarter', or 'This Year'. However, for custom date fields or additional date fields added beyond the primary filter, the Range dropdown is not available. Instead, you can use the 'Use relative date' option to apply flexible, dynamic date logic.

솔루션

 

All reports include a standard or primary date range filter and include a "Range" option with values available for selection in a drop down.

 

Default Primary Date Filter Range

 

 

The Range selection picker is only visible for date fields available for selection in the report's primary date range filter. The date fields available in the primary date filter typically include system date fields that are hard coded in the application as date literals including "Created Date" and "Last Modified Date" fields.

 

It's expected behavior and by current design for all other date fields including custom date fields or system date fields that are added to the report in addition to the primary or default date range to not show the "Range" dropdown or picklist selections.

 

To add a filter similar to what's available for the Range selections outside of the report's default primary date filter select "Use relative date" in the filter options and use available Relative Date Filters.

 

Use relative date

 

 

Knowledge 기사 번호

005228843

 
로드 중
Salesforce Help | Article