I’m trying to get a date from a webhook and send it to Airtable, but I keep getting errors. Anyone have suggestions?
1 Like
Hi @Mike_Fetherling ,
The formatDate function typically outputs text. Therefore, if the column in Airtable is a date field, you need to use the parseDate function to map the date correctly.
Best regards,
Msquare Automation
Gold Partner of Make
@Msquare_Automation
1 Like
Thanks for the suggestion! I changed it from formatDate to parseDate and now get this error: Failed to map ‘record.fldMZtmeHZPymLf5Q’: Function ‘parseDate’ finished with error! ‘Tuesday, October 22, 2024 8:24 AM’ is not a valid date or does not match the date format.
1 Like
Okay, I was not matching the format correctly. I changed it to this and it’s working.
2 Likes