# No past events **URL:** \ **Category:** Feature Requests\ **Created:** [September 27, 2019, 8:00am UTC](https://community.glideapps.com/t/no-past-events/633 "2019-09-27T08:00:22Z")\ **Posts on this page:** 20\ **Page:** 1
**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:** [September 27, 2019, 8:00am UTC](https://community.glideapps.com/t/no-past-events/633/1 "2019-09-27T08:00:22Z")
I am looking for a way to automatically not see events anymore that are in the past. So band is on tour and sees only the information of today and in the future. If a formula is the way to go, what would that formula look like? (Sorry to post this in feature request category, but i don’t see a category for general requests?) ---
**Author:** ![B\_Y](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/b_y/32/114_2.png) [@B\_Y](https://community.glideapps.com/u/B_Y)\ **Post date:** [September 27, 2019, 8:43am UTC](https://community.glideapps.com/t/no-past-events/633/2 "2019-09-27T08:43:13Z")
How about this? Have a new column like ={“Date (Modified)”;ArrayFormula(if(A2:A\ **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:** [September 27, 2019, 10:24am UTC](https://community.glideapps.com/t/no-past-events/633/3 "2019-09-27T10:24:35Z") Thanks, I’m going to try! ---
**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:** [September 27, 2019, 3:10pm UTC](https://community.glideapps.com/t/no-past-events/633/4 "2019-09-27T15:10:05Z")
We will have a filter for that soon 😉 ---
**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:** [September 27, 2019, 3:49pm UTC](https://community.glideapps.com/t/no-past-events/633/5 "2019-09-27T15:49:06Z")
Thanks @Mark then I wait for that! 😉 ---
**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:** [September 27, 2019, 8:27pm UTC](https://community.glideapps.com/t/no-past-events/633/6 "2019-09-27T20:27:58Z")
Shipped! ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/66250d063d822a3e35c8ba34ee6a61743d246f8d.png) ---
**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:** [September 27, 2019, 8:28pm UTC](https://community.glideapps.com/t/no-past-events/633/7 "2019-09-27T20:28:56Z")
Great! Thanks so much! ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [September 27, 2019, 9:14pm UTC](https://community.glideapps.com/t/no-past-events/633/8 "2019-09-27T21:14:13Z")
Cool. Have been missing the functionality. Thx ---
**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:** [September 27, 2019, 9:50pm UTC](https://community.glideapps.com/t/no-past-events/633/9 "2019-09-27T21:50:32Z")
But not yet in production, right? ---
**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:** [September 27, 2019, 10:31pm UTC](https://community.glideapps.com/t/no-past-events/633/10 "2019-09-27T22:31:06Z")
It is in production, but it will only show up for date/time columns. ---
**Author:** ![Carlos\_DeSilva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos_desilva/32/19965_2.png) [@Carlos\_DeSilva](https://community.glideapps.com/u/Carlos_DeSilva)\ **Post date:** [September 28, 2019, 12:39am UTC](https://community.glideapps.com/t/no-past-events/633/11 "2019-09-28T00:39:56Z")
Well done. It fixed another problem I had with my app (too many calender events.) Thanks! ---
**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:** [September 28, 2019, 6:59am UTC](https://community.glideapps.com/t/no-past-events/633/12 "2019-09-28T06:59:24Z")
I have a column called When with dates. In calendar view it’s clear Glide recognizes it like this by showing a calendar, but ‘is after’ doesn’t show up. Any idea what I do wrong? ![24](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/6859eba203c64de17f7ee0c7211fd19573bd59c5.png) ---
**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:** [September 28, 2019, 7:15am UTC](https://community.glideapps.com/t/no-past-events/633/13 "2019-09-28T07:15:26Z")
![54](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/23819ecf28572ea1b715edd772e9b9737fa93af7.png) ---
**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:** [September 28, 2019, 12:53pm UTC](https://community.glideapps.com/t/no-past-events/633/14 "2019-09-28T12:53:42Z")
@Mark Tried a new app and now it works . But … now glide interprets date the american way, where 12/09 is 12 sept here, Glide thinks it’s 9 dec. Any idea why that is and where I can change it? ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [September 28, 2019, 1:17pm UTC](https://community.glideapps.com/t/no-past-events/633/15 "2019-09-28T13:17:32Z")
Really hope glide will make it possible to use our own date format. I do have troubles concatenating date and time. Worked earlier on ---
**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:** [September 28, 2019, 1:18pm UTC](https://community.glideapps.com/t/no-past-events/633/16 "2019-09-28T13:18:27Z")
I didn’t have a problem either ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [September 28, 2019, 3:56pm UTC](https://community.glideapps.com/t/no-past-events/633/17 "2019-09-28T15:56:55Z")
It is a bug. Google sheets shows 12-06-2019 as june 12 but in glide it shows up as december 6. Google shows 13-06-2019 as june 13 and in glide is shows up as june 13 ---
**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:** [September 28, 2019, 4:20pm UTC](https://community.glideapps.com/t/no-past-events/633/18 "2019-09-28T16:20:31Z")
Please use the [date format we recommend](https://docs.glideapps.com/all/reference/layouts/calendar#formatting-dates-to-work-with-the-calendar). Date handling formatting is a very complex issue, but Glide will support it all eventually. Sorry for the difficulties. ---
**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:** [September 28, 2019, 5:02pm UTC](https://community.glideapps.com/t/no-past-events/633/19 "2019-09-28T17:02:38Z")
Just curious if there would be any advantage to writing to the sheet in ISO format. At least it’s a consistent international standard, still recognizable by google, and easy to work with when comparing dates as strings. Users can still use TEXT(value, “MM/DD/YYYY”) or TEXT(value, “DD/MM/YYYY”) to visualize the date however they want. I don’t have any experience working with different regional settings, so I could be mistaken, but I thought maybe this would help to simplify things. ---
**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:** [September 28, 2019, 5:09pm UTC](https://community.glideapps.com/t/no-past-events/633/20 "2019-09-28T17:09:47Z")
It’s fine for now using that, but it’s strange as a user that yesterday our european way worked and after filtering not. [Next page](https://community.glideapps.com/t/no-past-events/633.md?page=2)