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

Find Contribution by date changed in 3.2.x

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.2.2
    • Fix Version/s: 3.2.3
    • Component/s: CiviContribute
    • Labels:
      None

      Description

      Our accounting team noticed that their Find Contribution searches in 3.2.2 are not jiving with 3.0.0 searches in terms of numbers of contributions or totals when searching by date.

      If I search in 3.0.0 for contributions between July 1, 2010 and July 2, 2010, I get all contributions processed in the 48 hour period of July 1st and 2nd. In 3.2.2 I only get contributions processed on the 24 hours of July 1st 12:00 AM to July 2nd at 12:00 AM. Any contributions received during the day of the 2nd are not found in the search in 3.2.2.

      I tried to work around this change by setting Time to "24 hr" in the Advanced Date and Time settings (http://drupal.demo.civicrm.org/civicrm/admin/setting/preferences/date?action=update&id=7&reset=1) so accounting could specify a time period in 3.2.2 searches to mirror 3.0.0, but I get a database error due to a malformed sql query when I do.

      Sorry. A non-recoverable error has occurred.
      DB Error: syntax error

        Attachments

          Activity

            People

            • Assignee:
              sushant Sushant Paste
              Reporter:
              jbertolacci jason bertolacci
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: