Field of type date is being converted to String in Superset, how to fix this?

[sarcoex]

Hello,
I have connected Elasticsearch data with Superset, and can query all my indexes correctly. There is one issue, the dateField in my index is being converted to a String-type column (in Superset).
I have tried the following:

-Update the dataset column type to date but I run into an error.
-Changed the formatting of the date inside the window where we can edit the time format
-Updated the formatting inside the chart to match my time format

I could not find a solution and would appreciate some help?
Superset version: V3.1.2
superset dbapi: 0.2.11

The time format:
Mapping of the index/field
"dateField": {
"type": "date",
"store": true,
"format": "date_optional_time"
},

Format in superset:
2024-01-11T14:52:21.973Z