Forum Discussion
vincentcbv
Dec 02, 2025Copper Contributor
Filter Creation
Hello, I'm hoping this community can help me. I want to create a filter that will dynamically show all in progress tasks as of today's date. I've built the filter as follows: Start is less than or e...
Ignacio_Martin
Dec 03, 2025Iron Contributor
Hi Charlie
You can try using only numeric values ​​corresponding to the dates you'll use in your filter.
For example, using a formula, convert:
Number1 = [Start]
Number2 = [Finish]
Number3 = [Current date]
...and your filter would look like this:
If you want, you can change the current date that Project uses by default in Project > Project Info. The selection will be displayed when you apply the filter, or by refreshing the screen if the filter is active and the current date is changed. One of the quick ways to refresh the screen is with Ctrl+F2, Undo+Redo, Reload View, etc.
I hope this helps.
Ignacio