# Strange time behaviour

**URL:** <https://community.glideapps.com/t/strange-time-behaviour/5823>\
**Category:** Ask for Help\
**Created:** [March 25, 2020, 8:50am UTC](https://community.glideapps.com/t/strange-time-behaviour/5823 "2020-03-25T08:50:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\
**Post date:** [March 25, 2020, 8:50am UTC](https://community.glideapps.com/t/strange-time-behaviour/5823/1 "2020-03-25T08:50:52Z")

</div>

When I change the field in the data edito to time only, I get this:

 ![Screenshot 2020-03-25 09.48.21](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/5d804e820fd82bfcf56361bcd6f654e7eed476e8.png)

In the Google sheet it is this:

 ![Screenshot 2020-03-25 09.50.28](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/fee94e202f9c0d716f5850725ca7c692edb15ac6.png)

In the app it is this:  
 ![Screenshot 2020-03-25 09.51.34](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/541e8727bdba6e9c3a8147b7b717d24ad272eda6.png)

---

<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:** [March 26, 2020, 4:33am UTC](https://community.glideapps.com/t/strange-time-behaviour/5823/2 "2020-03-26T04:33:40Z")

</div>

I think you might need to have a complete date in MM/DD/YYYY HH:MM. The date probably doesn’t really matter, as long as its valid. Could probably use 01/01/2020.

The odd thing is I tried to do the same thing and I didn’t get any time to show up at all. Maybe it’s something to do with me using 12 hr time instead of 24 hr time. The data editor and the data in the app showed a blank time, but it seemed to work when I added the date in addition to the time in my sheet.

I still formatted the column in glide to only show time, but it appeared to work.

---

<div class="post-metadata">

**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\
**Post date:** [March 26, 2020, 6:02am UTC](https://community.glideapps.com/t/strange-time-behaviour/5823/3 "2020-03-26T06:02:30Z")

</div>

> [@Jeff\_Hager](#):
>
> MM/DD/YYYY HH:MM

Could @Mark say something about this? It would be a nuisance to have to fill in MM/DD/YYYY HH:MM when you only need HH:MM 😉

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [March 26, 2020, 1:03pm UTC](https://community.glideapps.com/t/strange-time-behaviour/5823/4 "2020-03-26T13:03:42Z")

</div>

Could you share the app, please?

---

<div class="post-metadata">

**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\
**Post date:** [March 26, 2020, 1:05pm UTC](https://community.glideapps.com/t/strange-time-behaviour/5823/5 "2020-03-26T13:05:28Z")

</div>

> **[On Tour](https://ontour.glideapp.io/)**
>
> All dates and data every artist needs on tour.