Date Filter

Get Help
1

Hi everyone, I've been working on Date Filter but it always filters my data 1 day ago. For example, whether I filter On 2021-11-03T03:00:00Z then it returns data with 2021-11-02T03:00:00Z.

Real example in image:
image

So, how can I fix it?

Thanks!!!

2

Hi @ranierroot
Post "Diagnostic Info" from Admin > Troubleshooting, and which database type you're querying.
Timezones are complicated: https://www.metabase.com/docs/latest/troubleshooting-guide/timezones.html

3

Database: redshift
Diagnostic Info:

{
  "browser-info": {
    "language": "en-US",
    "platform": "Linux x86_64",
    "userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.69 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "ANSI_X3.4-1968",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.10+9-LTS",
    "java.vendor": "Amazon.com Inc.",
    "java.vendor.url": "https://aws.amazon.com/corretto/",
    "java.version": "11.0.10",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.10+9-LTS",
    "os.name": "Linux",
    "os.version": "4.4.0-1102-aws",
    "user.language": "en",
    "user.timezone": "Etc/UTC"
  },
  "metabase-info": {
    "databases": [
      "mysql",
      "redshift",
      "athena",
      "h2"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "11.12"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.18"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2021-08-03",
      "tag": "v0.40.2",
      "branch": "release-x.40.x",
      "hash": "b884d29"
    },
    "settings": {
      "report-timezone": "America/Sao_Paulo"
    }
  }
}
4

@ranierroot

Upgrade to at least 0.40.5. Latest release is 0.41.1

What is is actual database column type of "Coleta"?
And is that question GUI or SQL? Do you see the same problem, when using the filters directly on the question instead of via the dashboard?

Check your query log on Redshift. It will help you better understanding of the query made.

Look in the timezone documentations to have a better understanding of all the places that can contain timezone, which is why it's so complicated.

5

Coleta Data Type is Date.
SQL question.
Yes! the problem appear in both question and dashboard.

I'll read the documentation. Thanks!

6

I found the problem. My database and the Metabase were with different timezone config.

Solved.