Greetings,
I have created a macro to update my reporting filters using the current date. This is a code snippet:
' Set the filter to tasks that should have finished by now
FilterEdit Name:="_Tasks Not Finished", _
TaskFilter:=True, Create:=True, OverwriteExisting:=True, _
FieldName:="Finish", Test:="is less than or equal to", Value:=Now(), _
FieldName:="% Complete", Test:="does not equal", Value:=100, _
FieldName:="Active", Test:="equals", Value:="Yes", _
ShowInMenu:=True
My problem is that the Active test is not working. When I run the macro and apply the filter, I receive all tasks meeting the date criteria on all tasks, inactive tasks included. Am I applying to wrong code test or type for Active?
I have searched Bing, Google, and every MS Project thread on this site but found no solution.
Thank you.