Date values disappear when turning a question into a model

[mere_data_analyst]

Database: MySQL

Metabase Version: 0.43.0

Issue: Date value disappear when turning a question into a model.

Steps taken prior to issue.

1. Asked a question which counts the distinct number of order, grouped by date (to the hour).

Example would look like this:

2. Turn the question into a model.

When I do this, the date column's values disappear. I have tried editing the meta data but it does not work.

As you can see, the Date column's value are gone.

I am not sure how to solve this or why the problem is occurring.

[flamber]

Hi @mere_data_analyst
It is caused by your "Add Time" column is using casting in the Data Model.
I've created an issue for it:
https://github.com/metabase/metabase/issues/22519 - upvote by clicking on the first post

[mere_data_analyst]

Ok, makes sense after reading the github thread. It is double casting.

Thanks!