Cannot change data type to date

[Tuinf1]

From the sample data
https://raw.githubusercontent.com/apache-superset/examples-data/master/tutorial_flights.csv
https://superset.apache.org/docs/6.0.0/using-superset/exploring-data

Why can't I change the data type to date if the data is "%Y-%m-%d"
The SQL expression doesn't change the data, and the "time" panel doesn't appear.

[dosubot[bot]]

Hi @Tuinf1! I'm Dosu and I’m helping the superset team.

Superset only enables the "time" panel if a column is explicitly marked as temporal in the dataset metadata (the is_dttm property). Using a SQL expression like CAST() or TO_DATE() in a calculated column does not change the underlying column's type or its temporal status, so the "time" panel won't appear.

To have Superset recognize a column as a date/time and enable time-based features, you need to either:

• Specify the column as a date during CSV upload using the "column_dates" option (now a dropdown in recent versions), or
• Edit the dataset schema after upload and mark the relevant column as temporal (set as "is temporal" in the UI).

After making this change, refresh the dataset so the UI picks up the update. Only columns marked this way will trigger the "time" panel and time-based controls in Explore. This process is metadata-driven and not affected by SQL expressions or calculated columns in the dataset config.
Reference

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}