I created a SQL question with a date type variable, and when I try to select the date for that variable, it only shows one week of each month:
What am I doing wrong? I dont see this problem if I use field type variable with a datetime field selected. But for this specific question I need to use date type variable.
Diagnostic Info:
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"metabase-info": {
"databases": [
"postgres",
"bigquery-cloud-sdk"
],
"run-mode": "prod",
"plan-alias": "pro-cloud",
"version": {
"date": "2026-03-18",
"tag": "v1.59.4",
"hash": "d4fb593"
},
"settings": {
"report-timezone": "Etc/GMT-0"
},
"hosting-env": "unknown",
"application-database": "postgres"
}
}