Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Unable to format date (Imported from Google Sheet)

Topic Labels: Dates & Timezones
299 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,
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

1 Reply 1

HI,

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