Bug related to filter by relative dates

Hi every one,

I think I found a bug, when we try to filter using Relative Dates,

I am trying to get all the records from the month before the previous Month,
so if now we are at 2023 Feb,
I need those records from 2022 Dec.

so using the filter I would pick the following:

And that's how it look like in the filters after applied

Now if you check the preview results you can notice some records from Jan 1 are included
Screen Shot 2023-02-09 at 1.50.38 PM

Any thoughts or workaround related to this?

Hey, just curious --

Do you know if you have a report time zone set in Metabase?

For example, your original timestamp could be "Dec 31 2022" in UTC, but displayed as "Jan 1 2023" in the report time zone.

Sorry for being late,
It is set to default,

Also I checked one of the months, it showed (32) distinct days

Can you also share Admin -> Troubleshooting -> Diagnostic Info please


  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/109.0",
    "vendor": ""
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.17+8-post-Ubuntu-1ubuntu220.04",
    "java.vendor": "Ubuntu",
    "java.vendor.url": "https://ubuntu.com/",
    "java.version": "11.0.17",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.17+8-post-Ubuntu-1ubuntu220.04",
    "os.name": "Linux",
    "os.version": "5.4.0-94-generic",
    "user.language": "en",
    "user.timezone": "Etc/UTC"
  "metabase-info": {
    "databases": [
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "13.8"
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.5.0"
    "run-mode": "prod",
    "version": {
      "date": "2023-01-17",
      "tag": "v0.45.2",
      "branch": "release-x.45.x",
      "hash": "819ce29"
    "settings": {
      "report-timezone": null