Loading

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

Publiceringsdatum: Mar 11, 2026
Beskrivning

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.

Lösning

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

Ytterligare resurser

Filter Operators Reference

Knowledge-artikelnummer

004923979

 
Laddar
Salesforce Help | Article