Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Unable to format date (Imported from Google Sheet)

Topic Labels: Dates & Timezones
1030 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Mayank_Agarwal
6 - Interface Innovator
6 - Interface Innovator

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
Mayank_Agarwal
6 - Interface Innovator
6 - Interface Innovator

HI,

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