# Filter and Visibility for Date Condition
**URL:** https://community.glideapps.com/t/filter-and-visibility-for-date-condition/52881
**Category:** Report a Bug
**Created:** [October 30, 2022, 12:38am UTC](https://community.glideapps.com/t/filter-and-visibility-for-date-condition/52881 "2022-10-30T00:38:03Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Fajar\_Prasetyo](https://community.glideapps.com/u/Fajar_Prasetyo)
#### Post date: [October 30, 2022, 12:38am UTC](https://community.glideapps.com/t/filter-and-visibility-for-date-condition/52881/1 "2022-10-30T00:38:03Z")
**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 accessing my app at 5 AM
so when the user access at 5 AM, data shows data from yesterday or blank.
**Expected behavior:**
I’m expected the condition date to work with the user’s time zone
**How to replicate:**
you need to use a different time zone to replicate the situation
using condition date
**Link to demo recording:**
I’ll update the link later, I need to wait until 12 AM my time to report this bug
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 30, 2022, 1:38am UTC](https://community.glideapps.com/t/filter-and-visibility-for-date-condition/52881/2 "2022-10-30T01:38:57Z")
This sounds like the same issue as this thread.
> [@Glide data not updated until after 9:00](https://community.glideapps.com/t/glide-data-not-updated-until-after-9-00/51449):
>
> 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 t…
I haven’t seen additional reports, but something seems suspicious.
What is the underlying time in most of your date entries? Are they possibly showing as 7am or around that time?
Do you have this checkbox and is it checked or not?
I suspect a bug, but answers to this question might help the team diagnose.
---
### Author:  [@Fajar\_Prasetyo](https://community.glideapps.com/u/Fajar_Prasetyo)
#### Post date: [October 30, 2022, 2:54am UTC](https://community.glideapps.com/t/filter-and-visibility-for-date-condition/52881/3 "2022-10-30T02:54:58Z")
hi Jeff, thanks for helping.
i don’t have a check box for respect time zones, maybe because i’m using google sheet.
> [@Jeff\_Hager](#):
>
> What is the underlying time in most of your date entries? Are they possibly showing as 7am or around that time?
because i tried to change my date format from date only to date and time, but i see, all formats showing 12am.
maybe i’ll try an experiment to combine data from google sheet and glide table for sheets related to date to get respect time zones check box
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 30, 2022, 3:19am UTC](https://community.glideapps.com/t/filter-and-visibility-for-date-condition/52881/4 "2022-10-30T03:19:00Z")
> [@Fajar\_Prasetyo](#):
>
> maybe because i’m using google sheet
Yes, that specific checkbox feature is only for glide tables.
> [@Fajar\_Prasetyo](#):
>
> all formats showing 12am.
OK. I was curious because the person in that other thread had an underlying time in one of his examples that was 9am, but he also was in a timezone 9 hours from GMT. I haven’t byet got a response from them if all of their dates have a 9am time, but based on what you found, maybe that’s not the issue and instead it’s in fact the timezone.
I’d be curious if you find anything in your experimentation.
It almost seems to be timezone related, and maybe it’s a bug introduced when glide added the 'Respect timezone option. @SantiagoPerez, this may be something to look into.
---
### Author:  [@Fajar\_Prasetyo](https://community.glideapps.com/u/Fajar_Prasetyo)
#### Post date: [October 30, 2022, 6:31am UTC](https://community.glideapps.com/t/filter-and-visibility-for-date-condition/52881/5 "2022-10-30T06:31:05Z")
because i can’t sync data automatically from google sheet and Glide Table,
So for a solution, i add another column in my google sheet with the name “Show” with this formula =ARRAYFORMULA(if(A2:A=“”,“”,if(C2:C\>=today(),C2:C-today(),“”)))
A2:A is for column ID
C2:C is for the column containing the date
and i change the filter or visibility condition on Glide:
if i want to show today only i’ll set “Show” equals “0”
if i want to show data today and after today, i’ll set “show” is greater or equal to “0”
please make sure Google sheet time zone same as your timezone
i’ll be back tomorrow to give the result of my experiment
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 30, 2022, 6:53am UTC](https://community.glideapps.com/t/filter-and-visibility-for-date-condition/52881/6 "2022-10-30T06:53:55Z")
> [@Fajar\_Prasetyo](#):
>
> So for a solution, i add another column in my google sheet with the name “Show” with this formula =ARRAYFORMULA(if(A2:A=“”,“”,if(C2:C\>=today(),C2:C-today(),“”)))
> A2:A is for column ID
> C2:C is for the column containing the date
If this is the solution, then something is horribly, horribly wrong.
Maybe it’s a bug, as Jeff suggests. But even if it is, there are much simpler workarounds than that.
Try this (in your Glide Table):
- Create two math columns using the following formulas:
```auto
Year(Now) * 10000
+ Month(Now) * 100
+ Day(Now)
```
- in the above, replace Now with the special “now” current date/time value
```auto
Year(Date) * 10000
+ Month(Date) * 100
+ Day(Date)
```
- in the above, replace “Date” with your record dates.
- Now instead of using “within today” as your filter condition, use “where Math-\>Now equals Math-\>Date”
---
### Author:  [@Fajar\_Prasetyo](https://community.glideapps.com/u/Fajar_Prasetyo)
#### Post date: [November 3, 2022, 1:35am UTC](https://community.glideapps.com/t/filter-and-visibility-for-date-condition/52881/7 "2022-11-03T01:35:06Z")
this totally works. thanks a lot.
in my experiment solution, i have a problem i need to wait for someone to refresh the sync data from a google sheet.
but with your solution, it totally works.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [November 3, 2022, 1:43am UTC](https://community.glideapps.com/t/filter-and-visibility-for-date-condition/52881/8 "2022-11-03T01:43:55Z")
> [@Fajar\_Prasetyo](#):
>
> in my experiment solution, i have a problem i need to wait for someone to refresh the sync data from a google sheet.
yeah, as a general rule it’s best to avoid spreadsheet formulas, precisely because of this sync delay.
glad it’s working for you now 👍
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [November 4, 2022, 1:43am UTC](https://community.glideapps.com/t/filter-and-visibility-for-date-condition/52881/9 "2022-11-04T01:43:56Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.