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

Search Builder: Contact created_date and modified_date filters not working

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.6
    • Fix Version/s: 4.6.4
    • Component/s: CiviCRM Search
    • Labels:
      None

      Description

      Contact/BAO/Query.php contains special handling for most date fields (birth_date, deceased_date, etc.). This is missing for created_date and modified_date. Without this, the resulting query adds a LOWER statement on the date string which causes it to return 0 rows in all cases.

      — Original post —
      In 4.6.0 the Javascript date picker provides the wrong format for MySQL. Either Javascript needs to output the date in the format 2015-05-07 or the process receiving it needs to reinterpret "20150507" to "2015-05-07".

        Attachments

        1. BadQILLDateFormatting.PNG
          235 kB
          David Greenberg
        2. Screen Shot 2015-05-29 at 2.45.30 PM.PNG
          197 kB
          David Greenberg

          Issue Links

            Activity

              People

              • Assignee:
                dgg David Greenberg
                Reporter:
                paulschaeff Paul Schaeffer
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: