Problems with date field filter

[nabievadayana]

Hello!
I need help, pls. I bumped into some problems with using date field filter when field that i connected with is timestamp.
I try to filter date with relative date filter, choose "Including today", but result ends till yesterday.
I think something wrong starts because of type of column, its timestamp - date with time. Can you suggest some way to fix this and to filter data correctly?

[Luiggi]

is the field in UTC time? what's the timezone of the server?

[nabievadayana]

Server is in UTC+3 timezone. Can timezone have effect on filtering?

[KotoriKo]

Hi! Looks like you have a similar problem to mine:

Specific dates filter bug

Hi! I create a new question and select a table. Add a filter by date. Specific dates... Between March 1 - 2. The preview shows the correct selection. Approximately 15 rows. When visualized in the table, it shows many more rows (~100) that do not match the filter that I set. I copied the generated sql query, testing query in HeidiSQL and it works correctly, same as in the preview. WHERE ( "dbo"."Plan"."DateTake" >= '2024-03-01 00:00:00' AND "dbo"."Plan"."DateTake" < '2024-03-02…

Maybe this is a bug with date filters in the latest version.
What version of the metabase are you using?

[nabievadayana]

Hi! Yeah, looks quite similar.
We're using 0.48.3 version.
And we didn't have this problem with previous version too.