Notifications

48 views

Description

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

Madrid

Cause

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

Resolution

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 

Article Information

Last Updated:2019-08-22 19:23:27
Published:2019-08-23