I’ve imported several tables into AT. They each had a day field (no time element). I just noticed all the dates are +1 day from what they should be. How is this even possible?
More importantly, how do I fix it?
Solved
Import Data with Dates add one day to all dates
+4Best answer by TheTimeSavingCo
Try adding a formula field that’ll output the previous day, then you can copy and paste the values into the original Date field:
DATEADD(
Date,
-1,
'days'
)
As to why this happened, it might be a timezone thing? Try importing the data into another table and this time make the date field a Single Line Text field instead. After you verify the date values, try converting it into a Date field to see what happens?
+32Try adding a formula field that’ll output the previous day, then you can copy and paste the values into the original Date field:
DATEADD(
Date,
-1,
'days'
)As to why this happened, it might be a timezone thing? Try importing the data into another table and this time make the date field a Single Line Text field instead. After you verify the date values, try converting it into a Date field to see what happens?
+1I had this happen and I noticed it was because Airtable interpreted them as UTC‑based timestamps during import. To fix it, re‑import using a strict date‑only format (YYYY‑MM‑DD) or adjust the field settings to ignore time zones, then correct the shifted values (the formula in the comment above is a quick fix for this).
For context (as I understand it): Airtable keeps all dates in UTC under the hood. Even if you import a “date‑only” field, Airtable often assumes the value is midnight UTC. If you’re in a timezone behind UTC, midnight UTC lands on the previous evening for you, so Airtable displays the next day.
🙃
+4@TheTimeSavingCo thanks for your answer. I created the formula, copied the values into a text field and then converted to a date. That worked.
@Angee B thanks for the explainer. I think you’re right. It uses midnight UTC. Thus all my dates were off by 1.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.