# Filter date on or after today not working in 2020 **URL:** \ **Category:** Ask for Help\ **Created:** [January 7, 2020, 1:43pm UTC](https://community.glideapps.com/t/filter-date-on-or-after-today-not-working-in-2020/3400 "2020-01-07T13:43:51Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![dionnehoutzager](https://avatars.discourse-cdn.com/v4/letter/d/bc79bd/32.png) [@dionnehoutzager](https://community.glideapps.com/u/dionnehoutzager)\ **Post date:** [January 7, 2020, 1:43pm UTC](https://community.glideapps.com/t/filter-date-on-or-after-today-not-working-in-2020/3400/1 "2020-01-07T13:43:51Z")
Hi, It might be a coincidence but the feature filter: \ turn up blanco in the new year? I tried different date formats but that didn’t help… Anyone ideas how to solve this? It’s a rowing workout schedule in which I like to show only future workouts. (it worked fine in 2019 🙂 ) [https://qeuuc.glideapp.io](https://qeuuc.glideapp.io) Regards, Dionne ---
**Author:** ![dionnehoutzager](https://avatars.discourse-cdn.com/v4/letter/d/bc79bd/32.png) [@dionnehoutzager](https://community.glideapps.com/u/dionnehoutzager)\ **Post date:** [January 8, 2020, 8:21am UTC](https://community.glideapps.com/t/filter-date-on-or-after-today-not-working-in-2020/3400/2 "2020-01-08T08:21:27Z")
Anyone who can help? I would be very grateful! ---
**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:** [January 8, 2020, 2:20pm UTC](https://community.glideapps.com/t/filter-date-on-or-after-today-not-working-in-2020/3400/3 "2020-01-08T14:20:32Z")
Screenshots of what you see in the builder might help. ---
**Author:** ![dionnehoutzager](https://avatars.discourse-cdn.com/v4/letter/d/bc79bd/32.png) [@dionnehoutzager](https://community.glideapps.com/u/dionnehoutzager)\ **Post date:** [January 10, 2020, 12:25pm UTC](https://community.glideapps.com/t/filter-date-on-or-after-today-not-working-in-2020/3400/4 "2020-01-10T12:25:23Z")
![IMG_4217](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a96bc468af910af946a19872c2b45ce13e43141f.jpeg) Hi Jeff, What I would like to show are only the dates after today. I managed to do that with the filter, but that stopped in 2020 (might be a coincidence though) ---
**Author:** ![dionnehoutzager](https://avatars.discourse-cdn.com/v4/letter/d/bc79bd/32.png) [@dionnehoutzager](https://community.glideapps.com/u/dionnehoutzager)\ **Post date:** [January 10, 2020, 12:26pm UTC](https://community.glideapps.com/t/filter-date-on-or-after-today-not-working-in-2020/3400/5 "2020-01-10T12:26:06Z")
![IMG_4218](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e7eefc02dd3931969bbe59f39903d08cdd8a8faf.jpeg) ---
**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:** [January 10, 2020, 1:03pm UTC](https://community.glideapps.com/t/filter-date-on-or-after-today-not-working-in-2020/3400/6 "2020-01-10T13:03:19Z")
I don’t see a year in your date field. It might be assuming that the year for your date is prior to 2020. I would consider a separate date field with a proper date format to use for the filter only. You can still use the Datum column to display to the user. ---
**Author:** ![dionnehoutzager](https://avatars.discourse-cdn.com/v4/letter/d/bc79bd/32.png) [@dionnehoutzager](https://community.glideapps.com/u/dionnehoutzager)\ **Post date:** [January 10, 2020, 2:18pm UTC](https://community.glideapps.com/t/filter-date-on-or-after-today-not-working-in-2020/3400/7 "2020-01-10T14:18:33Z")
Hi Jeff, I made an extra column, called “date”. But it still shows all rows in the sheet although the filter is “on and after today”. As if it can’t find out what "today’ is… I will upload some screenshots after this message. Thx so far already that you want to help! Very much appreciated! ---
**Author:** ![dionnehoutzager](https://avatars.discourse-cdn.com/v4/letter/d/bc79bd/32.png) [@dionnehoutzager](https://community.glideapps.com/u/dionnehoutzager)\ **Post date:** [January 10, 2020, 2:19pm UTC](https://community.glideapps.com/t/filter-date-on-or-after-today-not-working-in-2020/3400/8 "2020-01-10T14:19:44Z")
![IMG_4222](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1b6a85a64c99a250ca2e00bacb5ac0e7bd4364d2.jpeg) ---
**Author:** ![dionnehoutzager](https://avatars.discourse-cdn.com/v4/letter/d/bc79bd/32.png) [@dionnehoutzager](https://community.glideapps.com/u/dionnehoutzager)\ **Post date:** [January 10, 2020, 2:21pm UTC](https://community.glideapps.com/t/filter-date-on-or-after-today-not-working-in-2020/3400/9 "2020-01-10T14:21:56Z")
![IMG_4223](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/8e6b37891c84a3a37977478c597ad77a54c5b800.jpeg) ---
**Author:** ![dionnehoutzager](https://avatars.discourse-cdn.com/v4/letter/d/bc79bd/32.png) [@dionnehoutzager](https://community.glideapps.com/u/dionnehoutzager)\ **Post date:** [January 10, 2020, 2:23pm UTC](https://community.glideapps.com/t/filter-date-on-or-after-today-not-working-in-2020/3400/10 "2020-01-10T14:23:19Z")
![IMG_4224](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e925584739ed724e0759a01d318a07a74b6f0a71.jpeg) ---
**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:** [January 10, 2020, 2:27pm UTC](https://community.glideapps.com/t/filter-date-on-or-after-today-not-working-in-2020/3400/11 "2020-01-10T14:27:11Z")
I wonder if Glide is recognizing the dates in MM-DD-YYYY format instead of DD-MM-YYYY. Try changing them to YYYY-MM-DD instead to see if that works. ---
**Author:** ![dionnehoutzager](https://avatars.discourse-cdn.com/v4/letter/d/bc79bd/32.png) [@dionnehoutzager](https://community.glideapps.com/u/dionnehoutzager)\ **Post date:** [January 10, 2020, 2:31pm UTC](https://community.glideapps.com/t/filter-date-on-or-after-today-not-working-in-2020/3400/12 "2020-01-10T14:31:15Z")
Yes!!! That worked! You made my weekend! Thank you so much Jeff!