Date filter bring wrong results

Hello Guys,

Im having a strange behavior in a question with date filter, I am filtering by september 23 but the query brings to me september 22 data.

Could you help me?

Thank you

Hi @rubenssoto
Post "Diagnostic Info" from Admin > Troubleshooting.
Timezones are notoriously difficult. I would recommend that you look at this:
https://www.metabase.com/docs/latest/troubleshooting-guide/timezones.html

Hi @flamber how are you?

We are in Brazil so our timezone is gmt-3, on that specific field we already converted timezone to Brazillian timezone... so the problem is, metabase is converting the filter value to gmt-3 because metabase expect that data is on a different timezone.

Am i Right?

@rubenssoto Post "Diagnostic Info" from Admin > Troubleshooting, and check the query log on Redshift.