From d00a01d75985e7bdcd5b999f137a34e9a17c298e Mon Sep 17 00:00:00 2001
From: eileen <emcnaughton@wikimedia.org>
Date: Mon, 13 Jul 2020 17:47:08 +1200
Subject: [PATCH] Fix incorrect defaulting to the beginning rather than end the
 to-range day

---
 CRM/Report/Form.php | 4 ++++
 1 file changed, 4 insertions(+)

diff --git a/CRM/Report/Form.php b/CRM/Report/Form.php
index 2aa9b17f9a..3a56f8fdca 100644
--- a/CRM/Report/Form.php
+++ b/CRM/Report/Form.php
@@ -2185,6 +2185,10 @@ class CRM_Report_Form extends CRM_Core_Form {
       $sqlOP = $this->getSQLOperator($relative);
       return "( {$fieldName} {$sqlOP} )";
     }
+    if (strlen($to) === 10) {
+      // If we just have the date we assume the end of that day.
+      $to .= ' 23:59:59';
+    }
 
     if ($relative) {
       list($from, $to) = $this->getFromTo($relative, $from, $to, $fromTime, $toTime);
-- 
2.25.1