# Dates and times are off in Webhook

**URL:** https://community.glideapps.com/t/dates-and-times-are-off-in-webhook/32093
**Category:** Ask for Help
**Created:** [September 21, 2021, 8:40am UTC](https://community.glideapps.com/t/dates-and-times-are-off-in-webhook/32093 "2021-09-21T08:40:28Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Michael\_Pierce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_pierce/32/22958_2.png) [@Michael\_Pierce](https://community.glideapps.com/u/Michael_Pierce)
#### Post date: [September 21, 2021, 8:40am UTC](https://community.glideapps.com/t/dates-and-times-are-off-in-webhook/32093/1 "2021-09-21T08:40:28Z")

</div>

My dates and times are incorrect when I use a webhook to pass the data to Integromat.

In the Glide table, my dates & times are showing properly.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/5/755f58e4d216f7f15833c35e082825129ef0186f.png)

I pass the field in my webhook

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/1/216112cb99b805572d5458910d95cf5d105b01a1.png)

But when I receive the data in the Integromat webhook, the date & time is incorrect.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/4/a4caefe3cc5abbd5f9d75a94e125ef62821b1980.png)

Also in the Google Sheet, the date & time is displaying correctly.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/d/7dfa9aa7d4033c3c969dd837d6532ff84cd5b7a7.png)

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 21, 2021, 8:42am UTC](https://community.glideapps.com/t/dates-and-times-are-off-in-webhook/32093/2 "2021-09-21T08:42:51Z")

</div>

Looks like you’re getting hit by the timezones here. What timezone are you in?

Applying something like:

`formatDate(date; date format; UTC)`

will likely do the trick here.

Glide uses a default timezone of UTC+0 when they pass the date to your Sheet, that’s the most likely cause for this.

---

<div class="post-metadata">

### Author: ![Michael\_Pierce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_pierce/32/22958_2.png) [@Michael\_Pierce](https://community.glideapps.com/u/Michael_Pierce)
#### Post date: [September 21, 2021, 8:44am UTC](https://community.glideapps.com/t/dates-and-times-are-off-in-webhook/32093/3 "2021-09-21T08:44:10Z")

</div>

> [@ThinhDinh](#):
>
> formatDate(date; date format; UTC)

Thanks, I’ll give this a try.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 21, 2021, 8:44am UTC](https://community.glideapps.com/t/dates-and-times-are-off-in-webhook/32093/4 "2021-09-21T08:44:42Z")

</div>

Here are their tokens for formatting date & time.

> **[Tokens for date/time formatting Help Docs | Integromat Help Center](https://www.integromat.com/en/help/tokens-for-datetime-formatting)**
>
> Year, month, and day tokens Token Output Description YY 70 71 ... 29 30 2 digit year YYYY 1970 1971 ... 2029 2030 4 digit year Y 1970 1971 ... 9999 +

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 21, 2021, 8:45am UTC](https://community.glideapps.com/t/dates-and-times-are-off-in-webhook/32093/5 "2021-09-21T08:45:41Z")

</div>

I’d also advise checking your Integromat Time Zone settings (Profile → Time Zone Options)

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 21, 2021, 9:02am UTC](https://community.glideapps.com/t/dates-and-times-are-off-in-webhook/32093/6 "2021-09-21T09:02:58Z")

</div>

That’s the default if you don’t pass a timezone in the 3rd argument, so it looks like Michael is in GMT+12.