# Posting in the future

**URL:** <https://community.glideapps.com/t/posting-in-the-future/9056>\
**Category:** Report a Bug\
**Created:** [May 13, 2020, 2:23pm UTC](https://community.glideapps.com/t/posting-in-the-future/9056 "2020-05-13T14:23:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Naos\_Wilbrink](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/naos_wilbrink/32/769_2.png) [@Naos\_Wilbrink](https://community.glideapps.com/u/Naos_Wilbrink)\
**Post date:** [May 13, 2020, 2:23pm UTC](https://community.glideapps.com/t/posting-in-the-future/9056/1 "2020-05-13T14:23:37Z")

</div>

My app’s URL: [https://eochallenge.glideapp.io](https://eochallenge.glideapp.io)

People do a challenge in the app and they post their results. They do this from all over the world.  
Since the start of this challenge round, I’ve had some people posting in the future (1 hour in the future).

Does anyone know why this happens? Have others seen similar things? I would assume the time used is the server time,… so maybe some servers have the wrong time zone?

---

<div class="post-metadata">

**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:** [May 13, 2020, 2:28pm UTC](https://community.glideapps.com/t/posting-in-the-future/9056/2 "2020-05-13T14:28:41Z")

</div>

It’s my understanding that the date and time that comes from the date time special value is the date and time on the user’s device. Not a server time or UTC, like the app: Logins sheet.

---

<div class="post-metadata">

**Author:** ![Naos\_Wilbrink](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/naos_wilbrink/32/769_2.png) [@Naos\_Wilbrink](https://community.glideapps.com/u/Naos_Wilbrink)\
**Post date:** [May 13, 2020, 2:39pm UTC](https://community.glideapps.com/t/posting-in-the-future/9056/3 "2020-05-13T14:39:03Z")

</div>

☹ ok so, in that case, I should make my own Date Created solution? How do you deal with it?

---

<div class="post-metadata">

**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:** [May 14, 2020, 11:58pm UTC](https://community.glideapps.com/t/posting-in-the-future/9056/4 "2020-05-14T23:58:55Z")

</div>

In my case I prefer the user’s time as the data and time is specific to only them, so I haven’t had to work around it. Your best bet would be some sort of script that fills in a date whenever a new post is created and added to the sheet. That or make the user store their UTC offset in their profile and do the math in the sheet.

> [@Converting "-07" text to "-7" number value in google sheets](https://community.glideapps.com/t/converting-07-text-to-7-number-value-in-google-sheets/8770):
>
> Anyone know how to convert “-07” text to “-7” number value in google sheets? Been hitting a wall with this, can’t find the solution on Google. here’s the error i get [image] I tried =text(A1,"#") but doesn’t seem to work. It spits out the same value with the leading zero “-07” I’m trying to do a calculation using a column of numbers that have been stripped out of a string eg. “-07” stripped from UTC-07