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