Custom Search: Find Contributors by Aggregate Totals does not return results if 'Choose date range' is selected and end date is empty
Issue
If user has selected the 'Choose date range' date filtering option and he/she doesn't populate the end date field, the end date value becomes 0:
- The clause produced:
contrib.receive_date <= '0'
- Expected behaviour:
contrib.receive_date <= <current_date & time>
How to replicate
In https://dmaster.demo.civicrm.org
Fields
- Aggregate Total Between $ :
0
- ...and $ :
100000
- Contribution Dates :
Choose date range
- From:
01/01/2018
(no time supplied) - To: empty (no time supplied)