Currently when using any date ranges in the report builder conditions or filters, when an end date is set, this day is actually excluded from the dataset. This is because the report always uses the timestamp for Midnight of the selected day, where the expected behavior from the user end would be to see everything through 23:59 of that day.

Replication:

• Create a report from any data source.
• Create a date range condition for an applicable field
• With debugging on, if you convert the timestamp for the end date in the query, you can see that it's set to 00:00 for the selected date.

It would make more sense to the average user if the whole ending day is included. This change would affect pre-existing reports that are already configured with the above consideration, but would provide a more intuitive experience for users creating new reports.