# Set column - Time zone

**URL:** <https://community.glideapps.com/t/set-column-time-zone/24709>\
**Category:** Ask for Help\
**Created:** [March 25, 2021, 7:58am UTC](https://community.glideapps.com/t/set-column-time-zone/24709 "2021-03-25T07:58:50Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\
**Post date:** [March 26, 2021, 10:14am UTC](https://community.glideapps.com/t/set-column-time-zone/24709/9 "2021-03-26T10:14:35Z")

</div>

Solved it!!

> [@Timestamp with your local time NOT user's time zone](https://community.glideapps.com/t/timestamp-with-your-local-time-not-users-time-zone/24753):
>
> Happy to share a trick if you want to track activity in your App, e.g. how many users are active in the last X hours then how many the last Y minutes. This solves the issue that when you push the current time into a cell using a ‘Set columns’ action Glide pushes the current time on the user’s device versus your Local time. This can throw up issues, for example it may appear that users in Asia are active on the App in the future! So my solution is to leverage your Google sheet. The magic is to …

---

_[View the full topic](https://community.glideapps.com/t/set-column-time-zone/24709)._
