Fix TimeZone issues writing to Google Calendar

[Jeff_Hager]

I think Glide stores date and time as if they were UTC +0 time regardless if they really are or not. I think they they always put the zulu code at the end. You may have to use a template column or math column to offset your date to account for that. I’d probably use a math column. You can use Format Date to get your offset, then divide that by 24 and add/subtract that value from your date column. Basically trick Google into using the correct time.

I used the Google Calendar integration and facing issue with the Time that I filled with the time it is showing on the calendar

I solved this problem, Solution to this problem is we can make a new column named “New Start Date” where we can use the concat(start time, -5:30) Gsheet formula in my GLide app column and now I can use this column which will update the desired time in the google Calendar.

Google Add Calendar Event start time always at 02:00 hour

Under the hood, if I’ve understood things correctly, there is no such thing as only a date or only time. There are timestamps and a timestamp is a date and time in one object. And there are tons of difficulties related to timestamps (a date-time) because first these are displayed differently depending on region, device, etc. and second at a given timestamp (like “now”) the timestamp is are actually different based on where you are on the planet (time zones). I think that sums up the difficult…