# 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:** 1\
**Showing post:** 4

<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

---

_[View the full topic](https://community.glideapps.com/t/posting-in-the-future/9056)._