Time for when a message is received is showing in wrong timezone

(The Niqabi Coder Mum) #1

I am in GMT +2 timezone. On my account profile I have set it correctly to GMT +2 but when my bot receives a message, the “Date/Time Received” shows the time in GMT + 0.

I want to add the time a particular message is received in a google sheet but it enters the GMT + 0 time in my sheet as well.

Can you please help.

Thanks

(Daniel Beckett) #2

Hi @nqcm

Google takes the time as a UTC value and then offsets it based on your Google account timezone. You could either change your timezone to work with UTC or offset the time with +/- # Hours when creating the event. The Date & Time Handling support page has more information on offsetting dates and times.