Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
C
Core
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 975
    • Issues 975
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Operations
    • Operations
    • Incidents
  • Analytics
    • Analytics
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Members
    • Members
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • Development
  • Core
  • Issues
  • #1867

Closed
Open
Opened Jul 10, 2020 by wortfm@wortfm

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

civicrmResults

civicrmRange

Inquired at https://civicrm.stackexchange.com/questions/36100/choose-by-date-range-always-at-1200am

Reproduction steps

  1. Click on Select Date Range.
  2. Select/Enter July 1, 2020 at 12:00AM until July 1, 2020 at 11:59PM.
  3. 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.

civicrm_dateformat

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
Assignee
Assign to
None
Milestone
None
Assign milestone
Time tracking
None
Due date
None
Reference: dev/core#1867