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.