# Calendar Dates **URL:** \ **Category:** Ask for Help\ **Created:** [May 29, 2020, 1:18pm UTC](https://community.glideapps.com/t/calendar-dates/9982 "2020-05-29T13:18:39Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Shannon\_Joseph](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shannon_joseph/32/7689_2.png) [@Shannon\_Joseph](https://community.glideapps.com/u/Shannon_Joseph)\ **Post date:** [May 29, 2020, 1:18pm UTC](https://community.glideapps.com/t/calendar-dates/9982/1 "2020-05-29T13:18:39Z")
How do you remove past dates from a calendar listing? ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [May 29, 2020, 2:31pm UTC](https://community.glideapps.com/t/calendar-dates/9982/3 "2020-05-29T14:31:21Z")
In Glide, add a filter for ‘date is after now’. ---
**Author:** ![Angelia\_Baxter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/angelia_baxter/32/789_2.png) [@Angelia\_Baxter](https://community.glideapps.com/u/Angelia_Baxter)\ **Post date:** [August 5, 2020, 10:23am UTC](https://community.glideapps.com/t/calendar-dates/9982/4 "2020-08-05T10:23:32Z")
> [@sardamit](#): > > In Glide, add a filter for ‘date is after now’. Does your ‘date’ have to be named date? For example I have a column called ‘Start Date’ and "edd Date’ so I’d like to choose ‘Start date is after now’ so in the filter I selected ‘Start Date’ ‘is’ for the condition and typed in ‘after now’ but it doesn’t work. It says no upcoming events. Please advise. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [August 5, 2020, 10:50am UTC](https://community.glideapps.com/t/calendar-dates/9982/5 "2020-08-05T10:50:14Z")
Does your column have any data in it? Glide needs to recognize it as a date column before the appropriate filters will work. Just insert a “fake” row of data for testing purposes. ---
**Author:** ![Angelia\_Baxter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/angelia_baxter/32/789_2.png) [@Angelia\_Baxter](https://community.glideapps.com/u/Angelia_Baxter)\ **Post date:** [August 5, 2020, 10:57am UTC](https://community.glideapps.com/t/calendar-dates/9982/6 "2020-08-05T10:57:38Z")
Yes it has dates in it. Do you think maybe the TBD’s throw it off? Please see attached. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b1a654676bb66b7d41f9c8ed3fb899683d1b52af.png) ---
**Author:** ![Angelia\_Baxter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/angelia_baxter/32/789_2.png) [@Angelia\_Baxter](https://community.glideapps.com/u/Angelia_Baxter)\ **Post date:** [August 5, 2020, 11:02am UTC](https://community.glideapps.com/t/calendar-dates/9982/7 "2020-08-05T11:02:23Z")
> [@kyleheney](#): > > Does your column have any data in it? Glide needs to recognize it as a date column before the appropriate filters will work. Just insert a “fake” row of data for testing purposes. Also, here is what my inline list settings are. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/053119e52ca4d3abe336361a3dcf37692b26b5c3.png) ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [August 5, 2020, 11:24am UTC](https://community.glideapps.com/t/calendar-dates/9982/8 "2020-08-05T11:24:14Z")
I would not include the TBD values and see if it helps. You can always create an IFTHEN column in the editor to add the “TBD” to empty rows so that the Date values are recognized properly. You can see that Glide is viewing the column as Text and not a Date column. It could just be because the first row is text and not a date. ---
**Author:** ![Angelia\_Baxter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/angelia_baxter/32/789_2.png) [@Angelia\_Baxter](https://community.glideapps.com/u/Angelia_Baxter)\ **Post date:** [August 5, 2020, 12:00pm UTC](https://community.glideapps.com/t/calendar-dates/9982/9 "2020-08-05T12:00:47Z")
> [@kyleheney](#): > > You can see that Glide is viewing the column as Text and not a Date column. It could just be because the first row is text and not a date. I cleared all of the TBD’s out and left them blank. I removed date ranges and formatted the entire column as a date, it still doesn’t display the date though. I then tried changing the column header to ‘Date’ and more options appeared. ‘is on or after’ today worked worked and ‘now’ became a drop down item. I believe it was a combination of all of those things. Thanks so much for your help! ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [August 5, 2020, 12:13pm UTC](https://community.glideapps.com/t/calendar-dates/9982/10 "2020-08-05T12:13:42Z")
From my experience, the first row after the header row needs to be in the format you want Glide to view it as. Since your first row had a TBD in it, Glide couldn’t process it as a Date column. This will likely be the same for number columns, etc. — if the first row is text, Glide won’t view it the way you’d like it to be viewed. ---
**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 5, 2020, 12:34pm UTC](https://community.glideapps.com/t/calendar-dates/9982/11 "2020-08-05T12:34:55Z")
You can create a new date column in Glide, then it will add that column to the sheet and I think it would honor the format. And yes, don’t put TBD in the date column because it’s not the format it’s supposed to read.