# Need help: Function 'formatDate' finished with error!

**URL:** <https://community.make.com/t/need-help-function-formatdate-finished-with-error/58640>\
**Category:** Questions\
**Tags:** functions\
**Created:** [October 23, 2024, 11:43am UTC](https://community.make.com/t/need-help-function-formatdate-finished-with-error/58640 "2024-10-23T11:43:32Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mike\_Fetherling](https://avatars.discourse-cdn.com/v4/letter/m/fbc32d/32.png) [@Mike\_Fetherling](https://community.make.com/u/Mike_Fetherling)\
**Post date:** [October 23, 2024, 11:43am UTC](https://community.make.com/t/need-help-function-formatdate-finished-with-error/58640/1 "2024-10-23T11:43:32Z")

</div>

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](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/d/6d95877ec14c36e0316a66345b21c288b07b96ee.png)

 ![bundle1](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/9/d9ec2e3c22a62ca78b51a840603cec84ad6b4f40.jpeg)

---

<div class="post-metadata">

**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\
**Post date:** [October 23, 2024, 12:10pm UTC](https://community.make.com/t/need-help-function-formatdate-finished-with-error/58640/2 "2024-10-23T12:10:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Mike\_Fetherling](https://avatars.discourse-cdn.com/v4/letter/m/fbc32d/32.png) [@Mike\_Fetherling](https://community.make.com/u/Mike_Fetherling)\
**Post date:** [October 23, 2024, 12:58pm UTC](https://community.make.com/t/need-help-function-formatdate-finished-with-error/58640/3 "2024-10-23T12:58:42Z")

</div>

> [@Msquare\_Automation](#):
>
> parseDate function

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](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/e/4e74048e9021cb9e1937422936c29d75686b275a.png)

---

<div class="post-metadata">

**Author:** ![Mike\_Fetherling](https://avatars.discourse-cdn.com/v4/letter/m/fbc32d/32.png) [@Mike\_Fetherling](https://community.make.com/u/Mike_Fetherling)\
**Post date:** [October 23, 2024, 1:29pm UTC](https://community.make.com/t/need-help-function-formatdate-finished-with-error/58640/4 "2024-10-23T13:29:00Z")

</div>

Okay, I was not matching the format correctly. I changed it to this and it’s working.  
 ![parseupdate](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/f/3fcdb9f056d69305739bc2d2ca5c4ba050760697.png)

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [November 7, 2024, 7:12am UTC](https://community.make.com/t/need-help-function-formatdate-finished-with-error/58640/5 "2024-11-07T07:12:15Z")

</div>

This topic was automatically closed because it's resolved or inactive. Please, start a new topic.