Report time defaults to 12:00AM no matter what
Overview
When entering a time range within a date selection, time reverts to 12:00AM. This makes it difficult to select a single day since even putting in 12:00AM to 11:59PM the report returns no results. WordPress 5.4.2 and CiviCRM 5.26.2
Inquired at https://civicrm.stackexchange.com/questions/36100/choose-by-date-range-always-at-1200am
Reproduction steps
- Click on Select Date Range.
- Select/Enter July 1, 2020 at 12:00AM until July 1, 2020 at 11:59PM.
- No results are returned and the selection criteria is shown as going until July 1, 2020 at 12:00AM (see screen grab above)
Current behaviour
See Reproduction steps. No error messages in browser, but the web console shows that date_format is undefined.
The query shows receive_date >= 20200701000000) AND ( receive_date <= 20200701000000
Expected behaviour
----------------------------------------
_What should happen._
Environment information
----------------------------------------
<!-- Some of the items below may not be relevant for every bug - if in doubt please include more information than you think is neccessary. -->
* __Browser:__All Browsers
* __CiviCRM:__ _Master/5.20.0/5.19.1/5.18.2/..._ <!-- If this problem relates to an upgrade, then specify both old and new versions -->
* __PHP:__7.3
* __CMS:__ WordPress 5.4.2
* __Database:__ MariaDB 10.4
* __Web Server:__ _Apache 2.4
Comments
----------------------------------------
This could entirely be some configuration incorrect, but was directed here by those on stackexchange.
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information