Begin of the insertionThe `today` query operator is using `Date.today` which returns a date on the host machine's time zone. This is causing comparisons against the `created_at` column, stored inEnd of the insertion Begin of the deletion WhenEnd of the deletion UTC Begin of the insertionon the server.

Specifically when UTCEnd of the insertion and the host machine's current time are not referring to the same date, e.g. (UTC time is 01:00 May 31st, and the host's time is 17:00 May Begin of the insertion30th).

Found with a failing specEnd of the insertion Begin of the deletion 30th), specsEnd of the deletion that Begin of the insertiontested the `today` operator [https://github.com/opf/openproject/blob/95545a9c3341ba25901254583fa70fa3838eb7e8/spec/features/projects/projects\_index\_spec.rb#L491](https://github.com/opf/openproject/blob/95545a9c3341ba25901254583fa70fa3838eb7e8/spec/features/projects/projects_index_spec.rb#L491)End of the insertion Begin of the deletion test project filtering based on date filters fail. To narrow it down, those under https://github.com/opf/openproject/blob/95545a9c3341ba25901254583fa70fa3838eb7e8/spec/features/projects/projects\_index\_spec.rb#L491End of the deletion