There is one map and one dataset in my account. The dataset is synced to a Google Sheet to which my students add data.
All the layers of the map are derived from the one synced dataset. One of the layers is an animated timeline. The timeline worked fine before syncing, but now that it is synced, the data type of the "date" column is set as "string", and I'm not able to change it.
I found this answer on Stack Exchange, but the solution it refers to is a bit beyond my SQL ability (setting up a dynamic query I could probably manage, but the linked was reference to dates in Postgres is opaque to me at this point.): How do you change the data type of a column for a synced table?
Is there a way to maintain a "date" data format in a synced table?