SearchKit: granularity of relative dates
Consider the following search:
I would expect this, when run on March 14 2022, to find any donations made on or after March 14, 2021.
However, it takes "1 year" rather literally - if I run it at 3pm, it will only catch donations made on March 14, 2021 at or after 3pm. This doesn't match the behavior elsewhere in Civi, where we automatically add a "00:00:00" to the search when setting the beginning date of a search, or "23:59:59" when setting the end date of a search.
Proposal: When the interval unit is "Day", "Week", "Month" or "Year" we append the timestamp, much as we do in CRM_Contact_BAO_Query::dateQueryBuilder()
or CRM_Report_Form::dateClause()
.