Print this page

Why am I seeing less records when I use “BETWEEN” as my filter option on my dashboard, compared to my report?

Knowledge Article Number 000212921
Description Using “BETWEEN” in dashboard filter returns less records as compared to the source report.

Resolution This is an expected behavior. This filter option uses the logic “>= AND <”, thus will not include records that exactly matches the maximum value set on it (see image below for reference - The top one is the dashboard filter and bottom one is report):

User-added image

This means if  my report uses created date on certain object's records, then with the maximum date value as 2/1/2015 report pulls up the records created  on 2/1/2015 along with the other dates as mention in the filter

Whereas the dashboard filter will filter out the records created on 2/1/2015

promote demote