# Glide data not updated until after 9:00

**URL:** <https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449>\
**Category:** Ask for Help\
**Created:** [October 11, 2022, 8:34am UTC](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449 "2022-10-11T08:34:43Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![ed150n3](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed150n3/32/24339_2.png) [@ed150n3](https://community.glideapps.com/u/ed150n3)\
**Post date:** [October 11, 2022, 8:34am UTC](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449/1 "2022-10-11T08:34:43Z")

</div>

I have been running my app on the basic plan for a year and a half.  
Since 9/12, the data is no longer reflected in the spreadsheet, even though the spreadsheet has the data.  
And every day since then, without fail, the data suddenly appears after 9:00.  
The data source is Google SpreadSheet and the filter is set to show only the data of the day.(DATE is within today.)

Since we are using this service in Japan, it is probably because the time zone is UTC to determine if it is today or not.  
Is there somewhere I can set the time zone for the application?  
Or is there a way to have it determine if it is today in JST?

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [October 11, 2022, 5:46pm UTC](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449/2 "2022-10-11T17:46:22Z")

</div>

You could try changing the timezone of your GSheet.

File \> Spreadsheet Settings \> General \> Timezone

---

<div class="post-metadata">

**Author:** ![ed150n3](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed150n3/32/24339_2.png) [@ed150n3](https://community.glideapps.com/u/ed150n3)\
**Post date:** [October 13, 2022, 5:14am UTC](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449/3 "2022-10-13T05:14:50Z")

</div>

Spreadsheet data must be maintained in JST.  
Glide should make the decision based on time zone.  
Also, it was working fine until Sept. 12, did something change?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 13, 2022, 5:36am UTC](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449/4 "2022-10-13T05:36:55Z")

</div>

How is the date/time column configured in the Glide Data Editor?  
Can you show me?

 ![Screen Shot 2022-10-13 at 1.35.21 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/b/1b93b87ed226822fc7fcd2b024480acdde7cb483.png)

Also, if you click inside one of the cells inside the Data Editor, does the value match what you would expect to see?

![Screen Shot 2022-10-13 at 1.35.09 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/a/8ad3a6a090e7a397bf348adbe95266851a7d1de3.png)

---

<div class="post-metadata">

**Author:** ![ed150n3](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed150n3/32/24339_2.png) [@ed150n3](https://community.glideapps.com/u/ed150n3)\
**Post date:** [October 13, 2022, 5:46am UTC](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449/5 "2022-10-13T05:46:51Z")

</div>

Thx for reply.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/1/51c9a9a4f0c3fce1c075ba51605081eead39f5ec.png)  
Glide has the same content as the spreadsheet.

---

<div class="post-metadata">

**Author:** ![ed150n3](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed150n3/32/24339_2.png) [@ed150n3](https://community.glideapps.com/u/ed150n3)\
**Post date:** [October 13, 2022, 5:47am UTC](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449/6 "2022-10-13T05:47:22Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/a/6a3ddfbed3e0c7d7ff8a35b76d2e3df1cd23fbdf.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 13, 2022, 6:57am UTC](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449/7 "2022-10-13T06:57:55Z")

</div>

Okay, that looks fine.

How about your filtering - do you do that inside the data editor, or as a filter condition on a list?

Again, can you show me please?

---

<div class="post-metadata">

**Author:** ![ed150n3](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed150n3/32/24339_2.png) [@ed150n3](https://community.glideapps.com/u/ed150n3)\
**Post date:** [October 13, 2022, 7:31am UTC](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449/8 "2022-10-13T07:31:54Z")

</div>

Thanks,filter setting is here.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/eb6d93ae0db410ad1c33d0e88240fa83bfa4cc31.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 13, 2022, 7:41am UTC](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449/9 "2022-10-13T07:41:26Z")

</div>

For your second filter condition, please try changing that to “is not checked”

---

<div class="post-metadata">

**Author:** ![ed150n3](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed150n3/32/24339_2.png) [@ed150n3](https://community.glideapps.com/u/ed150n3)\
**Post date:** [October 14, 2022, 12:20am UTC](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449/10 "2022-10-14T00:20:29Z")

</div>

Thanks, Darren. I’l check it later, inform you the result.

---

<div class="post-metadata">

**Author:** ![ed150n3](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed150n3/32/24339_2.png) [@ed150n3](https://community.glideapps.com/u/ed150n3)\
**Post date:** [October 27, 2022, 12:46am UTC](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449/11 "2022-10-27T00:46:04Z")

</div>

The result is not changed.  
If the problem is due to the time zone, the previous day’s data should be displayed until 9:00, but nothing is displayed after 0:00.  
Therefore, we assume that this is not a time zone issue, but rather that a process was incorporated around September 12 that does not reflect today’s data until 9:00.

---

<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:** [October 27, 2022, 1:54am UTC](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449/12 "2022-10-27T01:54:58Z")

</div>

One of your screenshots shows an underlying time of 9:15. Do all of your dates consistently have a time on or after 9:00?

---

<div class="post-metadata">

**Author:** ![ed150n3](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed150n3/32/24339_2.png) [@ed150n3](https://community.glideapps.com/u/ed150n3)\
**Post date:** [November 2, 2022, 4:13am UTC](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449/13 "2022-11-02T04:13:53Z")

</div>

Sorry too late. Yes.

---

<div class="post-metadata">

**Author:** ![ed150n3](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed150n3/32/24339_2.png) [@ed150n3](https://community.glideapps.com/u/ed150n3)\
**Post date:** [November 2, 2022, 4:35am UTC](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449/14 "2022-11-02T04:35:10Z")

</div>

Sorry, I lied. the dates contains a time before 9:00. but, not displayed.

---

<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:** [November 4, 2022, 8:08pm UTC](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449/15 "2022-11-04T20:08:23Z")

</div>

I don’t know if you’ve seen this post I’ve attached below, but it sounds like it’s the same issue. If you read through it, @Darren_Murphy provided an alternative solution that should take care of your issue as well. It does seem like you have run into a bug that’s dependent on your timezone, so feel free to report that to Glide support if you want, but the Darren’s solution should work just as well for you.

> [@Filter and Visibility for Date Condition](https://community.glideapps.com/t/filter-and-visibility-for-date-condition/52881):
>
> My App/Pages support link: [https://go.glideapps.com/support/24d71d83-0110-4013-803f-91fa07576641](https://go.glideapps.com/support/24d71d83-0110-4013-803f-91fa07576641) Describe the bug: I’m working with the time zone UTC+7, and I realize something weird with the filter or visibility when I’m using a date as a condition. when I’m using the condition “within today”, data will appear at 7 AM my time (that indicates the condition date using UTC). in my case, this is a problem because “today” data should appear with my timezone because my user sometimes starts acce…

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [November 30, 2022, 12:53am UTC](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449/16 "2022-11-30T00:53:48Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
