Skip to main content

Incorrect data imported in date format

P
Forum|alt.badge.img+4

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):  

 

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




padd

3 replies

DisraeliGears01
Forum|alt.badge.img+16

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.

P
ATSolutionist
2 people like this
  • P
    Patryk_Sulejcza
  • ATSolutionist
    ATSolutionist
ATSolutionist
Forum|alt.badge.img+9
  • ATSolutionist
  • Participating Frequently
  • 20 replies
  • January 16, 2025

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

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 

 

 

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

 

 

Katelyninfo@consultasolutionist.com
P
1 person likes this
  • P
    Patryk_Sulejcza
P
Forum|alt.badge.img+4
  • Patryk_Sulejcza
  • Author
  • New Participant
  • 2 replies
  • January 20, 2025

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: 



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: 



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

padd

Reply


Most helpful members this week

Terms & Conditions