# Webhook date to Google Calendar

**URL:** <https://community.make.com/t/webhook-date-to-google-calendar/18265>\
**Category:** Questions\
**Tags:** format-date, google-calendar, webhooks\
**Created:** [October 25, 2023, 9:28pm UTC](https://community.make.com/t/webhook-date-to-google-calendar/18265 "2023-10-25T21:28:08Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nathan\_Gatt](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/nathan_gatt/32/17674_2.png) [@Nathan\_Gatt](https://community.make.com/u/Nathan_Gatt)\
**Post date:** [October 25, 2023, 9:28pm UTC](https://community.make.com/t/webhook-date-to-google-calendar/18265/1 "2023-10-25T21:28:08Z")

</div>

Hi  
I have a webhook going to a google calendar but the date/month format is incorrect.  
I am trying to use a setvariable tool to format it but the google calendar module is ignoring the variable.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/0/e0b344925fd9a1f5e59770c012007367d936c7af.png)

![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/7/074ae3e502ff839798d766a3b696b24507828780.png)

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/0/c0b2acd3c49ec326ba49196418c3aa06d813d6e4.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/3/c3eeacf1be04f5e98abbb0e3a8b58f660123b94d.png)

This is the date its producing:  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/2/c2c1ea20c2ebb560bbafaf329316a1af1f87c431.png)

Any help would be appreciated.

---

<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 26, 2023, 3:18am UTC](https://community.make.com/t/webhook-date-to-google-calendar/18265/2 "2023-10-26T03:18:26Z")

</div>

Hi @Nathan_Gatt

I observed that the data is in the format DD/MM/YYYY from the webhook. Therefore, I recommend utilizing the “parseDate” function within Google Calendar directly instead of setting it as a variable.  
I could see that in the start date field you have mapped two variable.

If you require additional assistance, please don’t hesitate to reach out to us.  
[MSquare Support](https://calendly.com/msquarepro/meeting)  
Visit us [here](https://www.msquare.pro/)  
[Youtube Channel](https://www.youtube.com/channel/UCqidlIIwbejxZmRUWBICcjQ)

---

<div class="post-metadata">

**Author:** ![Nathan\_Gatt](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/nathan_gatt/32/17674_2.png) [@Nathan\_Gatt](https://community.make.com/u/Nathan_Gatt)\
**Post date:** [October 26, 2023, 7:40am UTC](https://community.make.com/t/webhook-date-to-google-calendar/18265/3 "2023-10-26T07:40:09Z")

</div>

Thanks for the advise, I did try that by adding this into the start date:

{{parseDate(1.`49`; “DD/MM/YYYY”)}}YYYY-MM-DD){{1.`51`}}

I have tried all kinds of combinations of format date and parse date but the Google Calendar module produces this error:

HANDLED ERROR

- type  
BundleValidationError
- message  
Validation failed for 1 parameter(s).
- detail  
Invalid date in parameter ‘start’

Update: Got it working by using the following: {{formatDate(parseDate(1.`49`; “DD/MM/YYYY”); “YYYY-MM-DD”)}}{{1.`51`}}  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/8/b80bc20cbedbe5491c2e1deaf0866705e9a1837a.png)

Thanks

---

<div class="post-metadata">

**Author:** ![Michaela-Inactive](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/michaela-inactive/32/29_2.png) [@Michaela-Inactive](https://community.make.com/u/Michaela-Inactive)\
**Post date:** [October 26, 2023, 11:02am UTC](https://community.make.com/t/webhook-date-to-google-calendar/18265/4 "2023-10-26T11:02:53Z")

</div>

Hello @Nathan_Gatt welcome to the community 👋

I just wanted to quickly jump in and say congrats on solving this one with the assistance of @Msquare_Automation 👏 It’s great to see that you got things up and running!

Also, thank you very much for getting back to the community and sharing your final solution with us. This is super valuable and can help many folks searching for similar information in the future. 🙏

Keep up the great work 🍀

---

<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 9, 2023, 11:07am UTC](https://community.make.com/t/webhook-date-to-google-calendar/18265/5 "2023-11-09T11:07:15Z")

</div>