CiviCRM Community Forums (archive)

just ran into an interesting one for a client.
they want to do a contrib search for records on a single day via find contributions. so for date received they put the same date -- e.g. 7/20/10

however, the query that is built is: 2010-07-20 00:00:00 to 2010-07-20 00:00:00
which only retrieves contribs entered through the backend admin side -- because they don't have a timestamp

if a contrib was received via a contrib form at 2010-07-20 08:00:00 -- it is not included in the result list
if the criteria is changed to 2010-07-20 00:00:00 to 2010-07-21 00:00:00 -- it returns backend contribs for the following day as well -- i.e. they're not getting their "single day"

taking a look at the query right now, as the timestamp should be stripped from the criteria. but just curious if others ran into this.

same date in both. it is a bug. worked with Lobo on it today, so it should make it in the next revision I expect.

no --

if the criteria is changed to 2010-07-20 00:00:00 to 2010-07-21 00:00:00 -- it returns backend contribs for the following day as well -- i.e. they're not getting their "single day"

e.g. it returns contribs timestamped for BOTH 2010-07-20 00:00:00 and 2010-07-21 00:00:00

the query values should default to:
2010-07-20 00:00:00 to 2010-07-20 23:59:59