Bug related to filter by relative dates

[mohheader]

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

Any thoughts or workaround related to this?
Thanks

[nllho]

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.

[mohheader]

Sorry for being late,
It is set to default,

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

[TonyC]

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

[mohheader]

Sure

{
  "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": [
      "postgres",
      "h2",
      "bigquery-cloud-sdk"
    ],
    "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
    }
  }
}