Loosing possiblity to filter column as date

We have 2 models.
Model 2 contains date time column and i can filter that column by relative date as on screen

When i join Model 2 on Model 1
Model 2 is being shown as question &number& and I loose possibility to filter date time column from Model 2 as date, only as text

I recreated question several times, it didn`t help

running last metabase version:
"browser-info": {
"language": "en-US",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0",
"vendor": ""
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.21+9",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.21",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.21+9",
"os.name": "Linux",
"os.version": "5.4.0-126-generic",
"user.language": "en",
"user.timezone": "UTC"
"metabase-info": {
"databases": [
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "14.8 (Ubuntu 14.8-1.pgdg20.04+1)"
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.5.4"
"run-mode": "prod",
"version": {
"date": "2023-11-17",
"tag": "v0.47.8",
"branch": "?",
"hash": "639fa5e"
"settings": {
"report-timezone": null

I've also been having this issue since updating to 0.47.2
We're not using models but joining two questions and seeing the same inability to filter a datetime column.

1 Like

Thanks for your answer, at least i know that it is a common problem. Feels like we have to wait for another life quality bug fixing update :confused:

Has it become more fussy about data types? I'm storing a number in a varchar. Never had a problem displaying it in a gauge chart until recently. Now I need to cast it before it will work.

The pedant in me thinks this is a good thing. It was a worry at the time, though!

Not that I have noticed, just this particular instance with a datetime that comes from a joined question

Is it stored in the database as a datetime (or returned as a datetime from a view)? Is Metabase's metadata for the column correct?

It is stored as Datetime
In source table it is also Datetime and filter work nice
As soon as you join on top of anything, that column is being treated as text

Very odd. I can't replicate:

That was two questions, each saved as a model then a new question from those two models.
Also worked with one question joined to a saved question.

What are you joining on?

Hey, looks like it was fixed in last update
Checked it today with the same question, working fine
Also bug with pivot table was fixed (but nothing about it in patch release). Same here , i think

1 Like