Error Message after Changing Text format into Date format

Invalid query: {:stages [{:filters [nil nil nil [nil nil ["expression returning a date, time, or date time"]]]}]}

receiving this error code and researched and saw it was a problem previously in July but no current solutions. We ingest the file as a text format and then I will change it to a creation date format within admin which allows me to change it but not filter the column as a date.