I have read a number of post about capturing a user’s Local time in the data sheet. But I have a realy basic issue - I wan’t to store in the data sheet a single timezone (UTC), and to use the user’s phone or computer’s Local Time setting to display that date and time in the User’s Local time zone -…

[image] clock3 System/GMT Time - Solved! Project Showcase This is an extension of the request for System Time, please . There’s been a lot of questions for a while about how to get a universal time that can be shared for multiple users across multiple time zones. Most of …

Thanks, Jeff for your email. All of the topics in the discussion board, (and I have read many before now) are about converting a user input which is in UTC time-zone in the data sheet. I don’t want to convert UTC in the data sheet = it is already in this format in the datasheet - what I want it to…

I’m assuming it’s working. I’m in Central Time US. [Screenshot_20220725-121141]

Jeff – absolutely – I’ve been trying to figure this out for the last 18 months. Thanks so much for you help on this. My next big task, is to localize the TV channels – Cheers Anthony Kelly 68 Castleview Road, Clondalkin, Dublin 22, D22 YY42 M: +353 87 295 8667 [74F9F5BB6F5F4F3490FDACBFFB420B…

@Jeff_Hager @Anthony_Kelly → :wave: could you please enlighten me of the process: I do to have a time in google sheets stored as UTC (i.e. 2024-08-18T09:00Z) and even after reading this and the corresponding post, I’m not quite sure how to get this conversion to a local time - do I need to create ad…

This is a pretty old post. I think there are better ways now. I’m not near a computer at the moment to fully test, but you should be able to use a Format Date column to get your timezone offset. [Screenshot_20240818-092930] Then use Math column to divide it by 24 to get a decimal representation…

@Jeff_Hager – thanks for the quick reply! I dug deeper and based on the experimental field with plugins ( Format Date column | Glide ) I was able to just add the column (see screenshot) and reference the column with UTC date/time - and it looks like it works fine (I changed my system timezone to test …

… Bummer… :triumph: – I spoke too soon :smile: Column: DateUTC (text) with value: “2024-08-21T17:00Z” should return noon (I’m CDT) - but I’m getting Wednesday, August 21, 2024 at 10:00PM" (when double click on the value it shows: “2024-08-21T22:00:00.000Z”) My offset time is -5hrs but the system r…

You just have to change the sign if negative - make it positve, and vice versa. I should point out that this new feature doesn’t work for me - I am storing the date/time in the table in UTC, and the APP automatically shows local time, based on the users time settings. The new feature requires calc…

@AZJR are you still doing it your way, or my way?

Display UTC time in Glide App in users Local Time

Ask for Help

Jeff_Hager July 25, 2022, 11:24am 2

Topic		Replies	Views
🆕 "Respect time zone" support for Date & Time column in Glide Tables & Airtable Community Resources	17	1901	September 24, 2025
Timezone Conversion Ask for Help	3	1092	May 26, 2020
Fixing timezones with Google sheets (not glide tables) Ask for Help	6	695	August 19, 2023
Is Date Time Stamp - Local Time only? Ask for Help	9	882	May 26, 2020
Display date/time in local user's timezone Ask for Help	7	2022	June 25, 2020

Display UTC time in Glide App in users Local Time

Related topics