Tweet
Espo: 7.5.5
PHP: 8.1.21
MySQL: 8.0.28
When trying to filter an entity by a date (not datetime, just date) column using relative filters like "Today" and "This month", it does not take into account the timezone.
In this example we can see that when filtering by Today, shows Tomorrow's results. The key here is that this happens when UTC time IS tomorrow, despite having set the timezone different everywhere in the system. (America/Santiago UTC -4 in the example, screenshot taken after 20:00).
PHP: 8.1.21
MySQL: 8.0.28
When trying to filter an entity by a date (not datetime, just date) column using relative filters like "Today" and "This month", it does not take into account the timezone.
In this example we can see that when filtering by Today, shows Tomorrow's results. The key here is that this happens when UTC time IS tomorrow, despite having set the timezone different everywhere in the system. (America/Santiago UTC -4 in the example, screenshot taken after 20:00).
Comment