How do you remove past dates from a calendar listing?
In Glide, add a filter for âdate is after nowâ.
1 Like
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.
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.
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.
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!
1 Like
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.
1 Like
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.
1 Like