Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Incorrect data imported in date format

407 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Patryk_Sulejcza
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi, I'm facing an Issue with importing data into Airtable. 
I have date prepared in Google Sheets which I'm trying to import in 4 diffrent ways: just copying the range (data table) and pasting it, exporting the .csv file and trying to import it, exporting the .xlsx file and trying to import it and also via Google Sheet connection. I have tried diffrent types of date formats in Airtable. 
In all cases importing dates appear one day before the date, so that once I have the date (screenshot from Google sheets): 

TestDate
2025-01-15

while importing it appears to be (screenshot from Airtable): â€ƒ

Zrzut ekranu 2025-01-15 o 20.37.23.png

 

Has anyone faced such issue?
Thanks in advance, 
Best regards, 
Patryk




padd
3 Replies 3
DisraeliGears01
7 - App Architect
7 - App Architect

Usually copy/pasting dates works fine for me, but my expectation when there's a 1 day difference error is always a timezone issue. Does your Google Sheet data include any time information, even generic time info like everything is just set to 12:00AM? You might also export your Google Sheet as a CSV, and then take a look at the formatting in Excel to standardize.

ATSolutionist
6 - Interface Innovator
6 - Interface Innovator

I've had similar issues with Google Sheets -  you can standardize your dates in google sheets under format 

ATSolutionist_0-1736992336578.png

if that doesn't solve the issue - you could try importing the date into a plain text field and using a DateParse formula to clean it up 

ATSolutionist_0-1736992956551.png

 

 

DATETIME_PARSE({Date _ Plain},'MM/DD/YY')

 

 

Katelyn
info@consultasolutionist.com
Patryk_Sulejcza
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you @DisraeliGears01 @ATSolutionist for you replies and your help. I have checked and the date in .csv format at it does not include time zone, also have checked the date format in Google Sheets: 

Zrzut ekranu 2025-01-20 o 14.30.50.png

What I have found out is that while importing in the pop-up importing window it shows wrong date (1 day before) although after importing it shows correct ones. First screenshot shows the dates wthile importing and the other one after import: 

Zrzut ekranu 2025-01-20 o 14.33.31.png

Zrzut ekranu 2025-01-20 o 14.32.52.png

Already have send the issue to Airtable team, as this seems to be a bug. 
Best regards, 
Patryk 

padd