When I do a DateTime column search from the table list view, I sometimes got an incorrect result. Please see the following example:
If I search '2019-07-25', no record returned
If I search '2019-07-24', one record returned but the value is '2019-07-25'
Release or Environment
The system uses UTC timezone in the database, while the displayed value will be converted based on the selected instance timezone. In the example as above, '2019-07-25 08:48:27' is in Japanese timezone, so the value stored in the database is actually '2019-07-24 23:48:27' which is in UTC. The column search uses the operator 'start with' and try to match '2019-07-25' which returns nothing as expected
If you want to search in a DateTime column, you can use the filter and select the column there. It will convert the selected DateTime and perform search correctly