# Timezone Offset Issue

**URL:** <https://community.particle.io/t/timezone-offset-issue/34173>\
**Category:** Getting Started\
**Created:** [June 29, 2017, 6:17pm UTC](https://community.particle.io/t/timezone-offset-issue/34173 "2017-06-29T18:17:09Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vitesze](https://sea2.discourse-cdn.com/flex026/user_avatar/community.particle.io/vitesze/32/15427_2.png) [@Vitesze](https://community.particle.io/u/Vitesze)\
**Post date:** [June 29, 2017, 6:17pm UTC](https://community.particle.io/t/timezone-offset-issue/34173/1 "2017-06-29T18:17:09Z")

</div>

Whenever my sensor data is retrieved by a webhook, the events will show up with a ‘‘published-at:’’ value that is for the UTC timezone. I read some topics and tried adding ‘‘Time.zone(-8);’’ in my code, but this didn’t seem to have any effect.

Is there any way to send out the correct information? Help is very much appreciated 🙂

---

<div class="post-metadata">

**Author:** ![KyleG](https://sea2.discourse-cdn.com/flex026/user_avatar/community.particle.io/kyleg/32/11077_2.png) [@KyleG](https://community.particle.io/u/KyleG)\
**Post date:** [June 29, 2017, 6:23pm UTC](https://community.particle.io/t/timezone-offset-issue/34173/2 "2017-06-29T18:23:24Z")

</div>

Hello,

Let me ping someone that might be able to help, @rickkas7 are you able to assist?

Kyle

---

<div class="post-metadata">

**Author:** ![ScruffR](https://sea2.discourse-cdn.com/flex026/user_avatar/community.particle.io/scruffr/32/6952_2.png) [@ScruffR](https://community.particle.io/u/ScruffR)\
**Post date:** [June 29, 2017, 6:41pm UTC](https://community.particle.io/t/timezone-offset-issue/34173/3 "2017-06-29T18:41:50Z")

</div>

The event is timestamped by the cloud on arrival and by that time the cloud has no knowledge about the zone you have set on your device.  
This behaviour is common for global services.

If you want an event to carry your local time you need to send that info _in_ your event (either as payload or part of the event name)

---

<div class="post-metadata">

**Author:** ![Vitesze](https://sea2.discourse-cdn.com/flex026/user_avatar/community.particle.io/vitesze/32/15427_2.png) [@Vitesze](https://community.particle.io/u/Vitesze)\
**Post date:** [June 29, 2017, 8:36pm UTC](https://community.particle.io/t/timezone-offset-issue/34173/4 "2017-06-29T20:36:27Z")

</div>

Oh I see, that makes sense! So I will have to look for a way to put the date in the output data somehow…thanks!

Also, I have an other tricky issue Im struggling to solve: Right now, I have several values in my output data that appear as one big comma-seperated string. When using the webhook (ThingSpeak) to store it and export to Excel, I’m not able to neatly organize it.

Example of how it currently is:  
Field 1: Sensor1, 75.6,Pickup, 187

Example of how I would like it to be:  
Field 1: Sensor1  
Field 2: 75.6  
Field 3: Pickup  
Field 4: 187

Any way to not have all my data appear in one string?

---

<div class="post-metadata">

**Author:** ![ScruffR](https://sea2.discourse-cdn.com/flex026/user_avatar/community.particle.io/scruffr/32/6952_2.png) [@ScruffR](https://community.particle.io/u/ScruffR)\
**Post date:** [June 30, 2017, 4:51am UTC](https://community.particle.io/t/timezone-offset-issue/34173/5 "2017-06-30T04:51:36Z")

</div>

You could use `\n` or `\r\n` instead of the comma to have the line breaks in the string.  
But when you use webhooks you might consider using JSON format for key/value pairs.

---

<div class="post-metadata">

**Author:** ![Vitesze](https://sea2.discourse-cdn.com/flex026/user_avatar/community.particle.io/vitesze/32/15427_2.png) [@Vitesze](https://community.particle.io/u/Vitesze)\
**Post date:** [June 30, 2017, 3:02pm UTC](https://community.particle.io/t/timezone-offset-issue/34173/6 "2017-06-30T15:02:37Z")

</div>

Thanks, I’m reading Rickas’ tutorial right now (in case other readers would like to do the same as me: [https://github.com/rickkas7/particle-webhooksabout](https://github.com/rickkas7/particle-webhooksabout)) JSON and webhooks, I’m sure that will be of help with this.
