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