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.
John McGarvey shared this idea · Jul 11, 2014
How to Create a Date Filter for Today() or Now() ?
Comments
1 comment
Hi John,
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.
Regards,
Derrick
Please sign in to leave a comment.