Date Exclusions not working 100%

ezgif-1-5005fb045b

Using Metabase Cloud and not being able to exclude months/quarters, anyone else facing the same issue? Could this be a datatype issue or anything else on how my dates are stored in the warehouse?

please post diagnostic info. Do you see the same in the sample database?

Yes it is the same case with the sample database as well when I try to filter for eg: the 'Dates Received' on 'Invoices' table.

Diagnostic Info
{
"browser-info": {
"language": "en-GB",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.18+10",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.18",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.18+10",
"os.name": "Linux",
"os.version": "5.4.209-116.367.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"snowflake",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.17"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.5.0"
}
},
"run-mode": "prod",
"version": {
"date": "2023-03-29",
"tag": "v1.45.3.1",
"branch": "release-x.45.x",
"hash": "3b3097d"
},
"settings": {
"report-timezone": null
}
}
}

if you're using the cloud please write to help at metabase dot com. I think that's an issue on your frontend but we'll have to check

1 Like