I would love to be able to filter for a date that “is before/after OR equal to’“ via the filter bar. We have a shared checklist that several people look at, so I don’t want to persist the filter for everyone. This would help me see things in the list that are both overdue and due today.
Use case example:
Thanks!
That sounds like a thing for control to me. The standard control for a date period lets you select “past and equal to”.
You use controls to filter tables, but you can set the control to be personal or for everyone.
Working example you can copy
Hey Stephanie,
The control option above is a good option and you can also do it with a toggle and a filter using an if statement.
Here I made a toggle on this task page and called it Overdue Tasks
You can also add some conditional formatting to the table to hilight which tasks are overdue to make them easier to spot without the filter.
If you are set on using the filter bar, you can use before and choose an exact date rather than one from the list and just choose tomorrows date. Flag for that is that Coda remembers the filter that you used most recently so if you are using an exact date you will need to change each time you use it because it wont change automatically the way today does.
thank you @Reinout_Decock and @Tracy_Horner ! I appreciate the workarounds. TIL about controls, though the date range control didn’t have exactly the option I was looking for.
I ended up adding a checkbox column with a formula to determine if it’s overdue or due today, and then added that column to the filter bar. I do think adding it to the native date range filter bar would still be a nice quality of life improvement 
I agree that the filtering by date options are odd and insufficient.
For example, if I have a date column and want to filter to display all rows in the month of August, I would have to select “after July 31.” The more intuitive way to filter would be to select date is on or after August 1!
