After upgrading to make integration for my date field is throwing up errors even though my data is right. I have noticed this only for newly created scenarios. Previous scenarios seem to be running fine. I have made a simple integration to demo this step. The inbuilt typeform integration works fine.…

Hey there, I had the same exact issue, filed a ticket with support - not helpful. I resolved my issue when i enabled typecast (It’s the option named “Smart links”) in the airtable module. It tells airtable API to do its best to convert the string you give into the date. Hope that helps [Screen …

Check you raw call body and see if the date format matches Airtable documentation. You might have to format the date a specific way to make it work.

The question is why am I having to format this field when the other scenario is working just fine? I have never had to format date on any of my scenarios before. And direct integration through typeform works absolutely fine. This is occurring only after creating new scenarios after the upgrade to ma…

I am not sure exactly why the Airtable module in Make works differently than in Integromat. The error is returned by Airtable so it looks like Make does not send the date in the right format with your current mapping. Try to format the date like this: [Screenshot_20220226-080503]

The format seems to be right [Screenshot 2022-02-27 153428]

@erinviegas It could be the that typeform is exporting this date as text, and Make doesn’t properly send this over. Date field types can be very tricky sometimes. I don’t see your data or fields coming over from typeform, but before sending it to Airtable try a parseDate() to make sure its a date f…

[image] Bjorn.drivn: field types can be very tric It is exporting as date and not text. Even using the Parse function does not work. [Screenshot 2022-02-28 163351]

@erinviegas Can you show us how you’ve setup the airtable module?

I’ve made a video here to best try and explain the problem. Please pardon the sniffling. I have the flu.

Hey @erinviegas , like @Pavel_Abaev says you can enable the “Smart links”. It looks like this formatDate() function either has a bug or weird intention. I will escalate this to the development team to see if it can be resolved.

Wow, this worked! Thanks a lot @Pavel_Abaev :smiley:

Airtable is not parsing the date correctly

Questions

Topic		Replies	Views
Problems with date format in Airtable Questions connections , airtable , api , chatgpt , error	4	189	July 4, 2024
Date from make to airtable Questions	4	848	September 7, 2023
Parsing dates from Google Sheets to Airtable Questions google-sheets , airtable	2	470	December 21, 2023
Changing date formats from text to Airtable field Questions date-time-functions , airtable , regular-expressions , format-date	7	81	November 13, 2025
What is the correct number format for Airtable? Questions airtable , error	5	293	September 24, 2024

Airtable is not parsing the date correctly

Related topics