Unable to format date (Imported from Google Sheet)

I imported a database from Google Sheet - which has a date column.
Now when its imported - its being taken as long text.
Further, when I’m trying to convert it into date - its incorrect converting day as month and month as day - and some cells are even coming as blank.

Can someone help me understand how I can fix this?

Screen recording attached - Loom | Free Screen & Video Recording Software

Sample table (editable) - Sign up - Airtable


So Airtable support helped me on mail - they said I can import a CSV and do it!
And it worked, thanks!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.