-
Improvement
-
Resolution: Unresolved
-
Normal
-
None
-
None
-
None
When we search with a between date_from and date_to condition, specifying only dates and no times, the time is automatically defaulted to 00:00:00.
Created between 2023-07-19 and 2023-07-21 in fact searches for edits between 2023-07-19 00:00:00 and 2023-07-21 00:00:00 which does not include edits created on 2023-07-21.
Intuitively we would have thought it would return all edits for that day.
For this we have to use the little bit counter-intuitive Created between 2023-07-19 and 2023-07-22.
To make it more intuitive, I think we should still default time to 00:00:00 for date_from but we should default time to 23:59:59 for date_to.
BTW, I do know that to search one day, I should just use Created on 2023-07-21.