# Bug or something I'm missing: Special Value: Current date time wrong? **URL:** \ **Category:** Report a Bug\ **Created:** [February 18, 2020, 5:50pm UTC](https://community.glideapps.com/t/bug-or-something-im-missing-special-value-current-date-time-wrong/4714 "2020-02-18T17:50:07Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 18, 2020, 5:50pm UTC](https://community.glideapps.com/t/bug-or-something-im-missing-special-value-current-date-time-wrong/4714/1 "2020-02-18T17:50:07Z")
My app’s URL: [itemstore.glideapp.io](http://itemstore.glideapp.io) Users who add an item within the “Messages” tab will have their post added as a record to my spreadsheet. The Current date/time gets recorded to the “Timestamp” column. As seen in the screenshot below, one user’s record is 5 hours off from the others. Is it recording _their_ current time/date (timezones) and not the current time/date of the app owner? If so, how can this be adjusted so that all submissions are accurately relative to one another? ![Screen Shot 2020-02-18 at 12.49.51 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/076e971af3099fb0348e35e9343594c8003e1209.png) ![Screen Shot 2020-02-18 at 12.49.33 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/fe41f01991566952231951c9e3c2195ae3e76663.png) ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [February 18, 2020, 6:11pm UTC](https://community.glideapps.com/t/bug-or-something-im-missing-special-value-current-date-time-wrong/4714/2 "2020-02-18T18:11:15Z")
In my app on a form submit, if I use the timestamp special value it writes the time based on my spreadsheets timezone. But I am running it in the development environment. I guess you need to find someone that is not in your timezone to see if that makes a difference. I posted in your app under the name Geo and I’m in the Eastern time zone Z -5. How did my timestamp come out? Is your spreadsheet set to Eastern? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 18, 2020, 6:12pm UTC](https://community.glideapps.com/t/bug-or-something-im-missing-special-value-current-date-time-wrong/4714/3 "2020-02-18T18:12:49Z")
I’m also in Eastern 😉 ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [February 18, 2020, 6:39pm UTC](https://community.glideapps.com/t/bug-or-something-im-missing-special-value-current-date-time-wrong/4714/4 "2020-02-18T18:39:13Z")
You need to find out then what timezone your testers are in so you can nail down what the issue is. ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [February 18, 2020, 6:40pm UTC](https://community.glideapps.com/t/bug-or-something-im-missing-special-value-current-date-time-wrong/4714/5 "2020-02-18T18:40:56Z")
My suspicion is that since Glide is generating the timestamp they may be using the users time zone and not that of the sheet. I haven’t tested that but it seems plausible. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 18, 2020, 6:43pm UTC](https://community.glideapps.com/t/bug-or-something-im-missing-special-value-current-date-time-wrong/4714/6 "2020-02-18T18:43:53Z")
That’s exactly what I’m suspecting as well. If so, then doing any sort of calculating/sorting by date with this value is unreliable ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [February 18, 2020, 6:46pm UTC](https://community.glideapps.com/t/bug-or-something-im-missing-special-value-current-date-time-wrong/4714/7 "2020-02-18T18:46:13Z")
You could ask and store the users timezone as part of their profile I guess. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 18, 2020, 6:59pm UTC](https://community.glideapps.com/t/bug-or-something-im-missing-special-value-current-date-time-wrong/4714/8 "2020-02-18T18:59:59Z")
Hm. Yes…a workaround for now…kinda a pain though. This should be a separate special value. Current Time/Date (User) VS. Current Time/Date (App owner/Spreadsheet) ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [February 18, 2020, 7:20pm UTC](https://community.glideapps.com/t/bug-or-something-im-missing-special-value-current-date-time-wrong/4714/9 "2020-02-18T19:20:22Z")
They should just return GMT in my opinion, but I’m sure they would get plenty of complaints about that. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 21, 2020, 1:56pm UTC](https://community.glideapps.com/t/bug-or-something-im-missing-special-value-current-date-time-wrong/4714/10 "2020-02-21T13:56:46Z")
Definitely seems like user’s time. I tested one of my apps by adding a record, then changed my computer’s timezone and submitted another record. The datetime value in the sheet followed the timezone my computer was set to at the time. I like the idea of GMT or app owner defined zone (maybe just an option to set any zone in the builder) as a separate Date/Time special value.