Forum Discussion
Filter Creation
I want to define "in progress" as the Start Date is before today and the Finish Date is after today. In other words:
Start Date <=Today, and Finish Date >=Today.
I don't want to use the % Complete, Actual Start or Actual Date fields. But it's not looking like I can create a custom filter that will calculate based on Start/Finish Dates. I'll probably have to use % Complete so it will add a value in the Actual Start/Actual Finish Date fields.
vincentcbv,
I don't understand how a task can be "in progress" if it never actually started. You must have an unusual way of interpreting progress. Nonetheless, now that I understand what you want (i.e. tasks that "should be in progress"), yes, you can use an extension of the solution I presented previously, namely.
Create a custom Flag field with the following formula:
Flag1= IIf([Start] <= [Current Date] and [Current Date]<= [Finish],"yes","no")
Filter on the Flag1 field.
John