Loading

Records from the specified end date are excluded when using the 'between' filter operator in a Dashboard Filter

Date de publication: Mar 11, 2026
Description

This article explains that when filtering a Dashboard using the 'between' operator, records matching the end date are not included by design. It also describes how to adjust the end date to include those records.

Résolution

The 'between' operator functions as "greater than or equal to" the start value and "less than" the end value. This means the value specified as the end date is not included in the results. This is the expected behavior and applies to field data types other than date.

Therefore, to filter for a date range that includes April 30, 2025 (e.g., April 1, 2025, to April 30, 2025), you must set the end date to the following day.

 

Example:- Start date: April 1, 2025 / End date: May 1, 2025

Ressources supplémentaires

Filter Operators Reference

Numéro d’article de la base de connaissances

004923979

 
Chargement
Salesforce Help | Article