# List businesses open "now" **URL:** \ **Category:** Ask for Help\ **Created:** [January 15, 2020, 11:56pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641 "2020-01-15T23:56:05Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [June 10, 2020, 2:49pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/21 "2020-06-10T14:49:48Z")
This is brilliant ! ---
**Author:** ![Rik\_Ahlberg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rik_ahlberg/32/1003_2.png) [@Rik\_Ahlberg](https://community.glideapps.com/u/Rik_Ahlberg)\ **Post date:** [June 16, 2020, 3:02pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/22 "2020-06-16T15:02:36Z")
I’ve been experimenting with your solution, but can’t for the life of me figure out how you get the “before now” and “after now” data into the filter fields. I’m probably missing something obvious… thanks for posting your solution, I hope I can get it to work 🙂 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 16, 2020, 3:08pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/23 "2020-06-16T15:08:32Z")
Make sure you’re filtering on a datetime column. Does Glide read that column as datetime, or somehow it’s read as text? ---
**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:** [June 16, 2020, 3:29pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/24 "2020-06-16T15:29:49Z")
Sometimes glide won’t automatically recognize the type of column. Especially if the first row or possibly other rows don’t contain any data in that column. If necessary, you could create a new column in Glide, but specify it as a date column. It will also create it in the sheet. Then switch over to using the new column. But overall, what @ThinhDinh is saying makes sense. You might not be getting the date compare options because your column isn’t being seen by glide as a date column ---
**Author:** ![Rik\_Ahlberg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rik_ahlberg/32/1003_2.png) [@Rik\_Ahlberg](https://community.glideapps.com/u/Rik_Ahlberg)\ **Post date:** [June 16, 2020, 3:30pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/25 "2020-06-16T15:30:40Z")
In my copy of @Jeff_Hager’s app, the columns show up as “text” in the Glide data editor: [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/8d43aab564e3209db61f4f37b9916dc04b479aad.png) ](https://dl.dropboxusercontent.com/s/bgb21w2v44rczl8/glide-columns.png?dl=0) The filter works in the copy of his app, but even there I don’t get the time options (before, after, etc.) in the filter popup if I try to edit it. Bug? [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e821d2d587c42815bddcda6a0cb285f2c0ddf0cd.png) ](https://dl.dropboxusercontent.com/s/57fpzuivezn7n49/glide-filter-missing-options.png?dl=0) ---
**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:** [June 16, 2020, 3:32pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/26 "2020-06-16T15:32:02Z")
I’ll try to take a look later today to see how I have it set up. ---
**Author:** ![Rik\_Ahlberg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rik_ahlberg/32/1003_2.png) [@Rik\_Ahlberg](https://community.glideapps.com/u/Rik_Ahlberg)\ **Post date:** [June 16, 2020, 3:57pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/27 "2020-06-16T15:57:29Z")
Ok - Glide just didn’t copy the column formats along with the copy of the app. I created new columns in the Glide editor set to Date/Time and then copied the data over in the Google spreadsheet. That fixed it for me. Thanks for the help! ---
**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:** [June 18, 2020, 4:06am UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/28 "2020-06-18T04:06:48Z")
I took a look at my copy. I’m guessing that maybe when you copied it, ‘Closed’ was showing in the column, so it wasn’t initially recognized as a date column. ---
**Author:** ![Rik\_Ahlberg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rik_ahlberg/32/1003_2.png) [@Rik\_Ahlberg](https://community.glideapps.com/u/Rik_Ahlberg)\ **Post date:** [June 19, 2020, 12:09pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/29 "2020-06-19T12:09:24Z")
I got this working perfectly and then found out that I have a bunch of use cases that I can’t figure out how to implement. There are multiple businesses that are open in discontinuous hours – e.g., for breakfast, lunch, dinner, etc., with gaps in between when they are closed. I spent the better part of a day trying to come up with a scheme to address this, but it got away from me. Any thoughts on how to build this? Or can anyone recommend an expert who might be interested in building this as a work-for-hire? ---
**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:** [June 22, 2020, 6:24pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/30 "2020-06-22T18:24:03Z")
I would probably just duplicate all of the columns, so the first set would be Breakfast, the second set Lunch and the third set Dinner. Maybe using different visibility, you could display different or multiple tables that show the hours. ---
**Author:** ![AZJR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/azjr/32/78923_2.png) [@AZJR](https://community.glideapps.com/u/AZJR)\ **Post date:** [August 23, 2020, 11:08pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/32 "2020-08-23T23:08:25Z")
Hello – Thank you @Jeff_Hager for the examples - very helpful! I’m too looking for the solution where businesses open on the same day on different times (i.e. 9-11am and then 5-8pm) - I took a shot at this without success thus far ☹ – any thoughts? thanks!! ---
**Author:** ![AZJR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/azjr/32/78923_2.png) [@AZJR](https://community.glideapps.com/u/AZJR)\ **Post date:** [August 24, 2020, 5:17pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/33 "2020-08-24T17:17:30Z")
👋 Hello All 🙂 – I actually made this work: [https://lacc-poc.glideapp.io/](https://lacc-poc.glideapp.io/) --\> as usual, there might be a way of making it simple® with less code, but hey - it’s working 😃 🖖 ---
**Author:** ![AZJR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/azjr/32/78923_2.png) [@AZJR](https://community.glideapps.com/u/AZJR)\ **Post date:** [August 25, 2020, 1:09pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/34 "2020-08-25T13:09:32Z")
Hello again - (FYI: I’m new to glide and still discovering it) – this somewhat makes me perplexed: out of blue, two out of four columns that initially were formatted as date, now are shown as boolean and cause to break the calculation of “Open Now” - is this a common thing in glide? Last night I checked and all seemed fine - this morning I have boolean … – thoughts? Thank you! ![Screen Shot 2020-08-25 at 08.10.44](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/069de9e6e9803399239abf1ae1dfe853f623ada7.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 25, 2020, 1:13pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/35 "2020-08-25T13:13:38Z")
What are the values in that column in your sheet? ---
**Author:** ![Rik\_Ahlberg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rik_ahlberg/32/1003_2.png) [@Rik\_Ahlberg](https://community.glideapps.com/u/Rik_Ahlberg)\ **Post date:** [August 25, 2020, 1:43pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/36 "2020-08-25T13:43:08Z")
I also found that Glide keeps changing the column formats from Date/Time to Text on its own, so the calculations break. Even when I create a new column in the data editor as Date/Time, it eventually switches to being just text. It does not like the arrays. (I have t seen it switch to Boolean on me… yet!) This is way too unreliable, so I switched to doing all the calculations in the sheet rather than with Glide columns. That works fine with a Pro account but won’t work for a free app. ---
**Author:** ![AZJR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/azjr/32/78923_2.png) [@AZJR](https://community.glideapps.com/u/AZJR)\ **Post date:** [August 25, 2020, 1:44pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/37 "2020-08-25T13:44:45Z")
@ThinhDinh - hello: thanks for prompt response! it was however my oversight - had an error in array formula AND there might have been a lag in updates between my sheet and glide - I think it’s fixed now ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 25, 2020, 1:46pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/38 "2020-08-25T13:46:18Z")
The column type depends on what you have in the Sheets. Are you sure your column contains actual datetime value? ---
**Author:** ![AZJR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/azjr/32/78923_2.png) [@AZJR](https://community.glideapps.com/u/AZJR)\ **Post date:** [August 25, 2020, 2:05pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/39 "2020-08-25T14:05:17Z")
it was a silly mistake - proves how important is to pay attention to details 🙂 The formula had typo and that caused the answer to return “FALSE” thus making it boolean… 🙂 - it was my mistake repeating the same week # 7x `IF(WEEKDAY(NOW()) = 2` instead of 1,2,3… etc. – thanks for following up!!! here is the corrected formula I used: ![Screen Shot 2020-08-25 at 09.07.41](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1788b35de47a7fe9c9b5ff17d2ebed759ed502dc.png) ---
**Author:** ![AZJR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/azjr/32/78923_2.png) [@AZJR](https://community.glideapps.com/u/AZJR)\ **Post date:** [August 29, 2020, 9:36am UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/40 "2020-08-29T09:36:50Z")
Hello - please advise as I’m not sure what I’m dealing with here: The arrayformula (as used initially in @Jeff_Hager solution) works smooth in google sheets, recognizing IF(WEEKDAY(NOW()) = … however on the app-side (data view), that column does not refreshes automatically causing the entire calculation to break… in other words: I checked the app today, August 29 – the google sheets correctly shows todays date, however on the app-side in data the rows are “stuck” at August 27… I’m guessing this has something to do with the background refresh, which is “natively available” only in pro apps – am I correct? ---
**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:** [August 29, 2020, 4:09pm UTC](https://community.glideapps.com/t/list-businesses-open-now/3641/41 "2020-08-29T16:09:29Z")
That would be correct. It’s not going to update automatically, unless you are using the background refresh pro feature. Your app would either need background refresh or some type of input from the app that would cause it to resync with the Google sheet. The NOW() function in Google sheets is part of a handful of functions called Volotile functions. They will not automatically update and resend data to glide with updates. They need some sort of input or interaction with the sheet before they will update. It’s complicated to explain, but there is info out there about it. My solution was also developed before many current features were available in glide, so it might be possible to build more of this within glide now. [Previous page](https://community.glideapps.com/t/list-businesses-open-now/3641.md?page=1)