From 20a120a51489ecf7682c4241664d85ff0b6eccf8 Mon Sep 17 00:00:00 2001 From: Seamus Lee Date: Tue, 14 Jul 2020 08:19:48 +1000 Subject: [PATCH] dev/core#1867 Ensure that the qill matches the filter when no time is supplied --- CRM/Report/Form.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/CRM/Report/Form.php b/CRM/Report/Form.php index 3a56f8fdca..2bd8d4d506 100644 --- a/CRM/Report/Form.php +++ b/CRM/Report/Form.php @@ -3310,7 +3310,10 @@ WHERE cg.extends IN ('" . implode("','", $this->_customGroupExtends) . "') AND if (!empty($this->_params["{$fieldName}_relative"])) { list($from, $to) = CRM_Utils_Date::getFromTo($this->_params["{$fieldName}_relative"], NULL, NULL); } - + if (strlen($to) === 10) { + // If we just have the date we assume the end of that day. + $to .= ' 23:59:59'; + } if ($from || $to) { if ($from) { $from = date('l j F Y, g:iA', strtotime($from)); -- 2.25.1