Need help: Function 'formatDate' finished with error!

Questions
1

I’m trying to get a date from a webhook and send it to Airtable, but I keep getting errors. Anyone have suggestions?

format date
format date1091×379 58.6 KB

bundle1
bundle1449×425 95.7 KB

2

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

3

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.

parseDate
parseDate415×101 5.5 KB

4

Okay, I was not matching the format correctly. I changed it to this and it’s working.
parseupdate