Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-17172

Search Builder : searching on Date = X does not work as expected for date / time fields

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 4.6.8
    • Fix Version/s: Unscheduled
    • Component/s: CiviCRM Search
    • Labels:
      None
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Needs Funding

      Description

      Using Search Builder to filter on any date / time field (e.g. Receipt Date) = YYYYMMDD does not work as expected because the query is only looking at date, not time.

      Example: A contribution with Receipt Date = 20150908 08:20 will NOT match Receipt Date = 20150908. User will need to search on Receipt Date > 20150908 and < 20150909 if they need to search on an single date.

      ---- Original Post —
      Just ran into something new. I was searching for contributions with the receipt date set to today but couldnt find them. Turns out that operator is broken. When searching with operator > (greater than) it worked out ok. See attached screenshots from the sandbox.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              magnolia61 Richard
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: