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

This article explains why records matching the specified end date are excluded when using the 'between' operator in a Dashboard Filter, and how to adjust the filter to include them.

Why End-Date Records Are Excluded

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.

How to Include the End Date's Records

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