How to Create a Date Filter for Today() or Now() ?
I am trying to create a filter against a Date field to display all records prior to today, but I am only able to select a specific date from a pop-up calendar control.
Derrick Kotlus commented
At the moment, we do not have the ability to select "today" or "now" in a date filter. That being said, we are in the process of improving filters by adding more options. Be on the lookout for additional options in the future!
In the mean time, you can create a calculated field in your table that outputs a 1 if the date is prior to today. You can then create a filter on this new field effectively creating this "is before today" filter that you are looking for.