Hi,



I have had a search but couldn't find the answer.

I am trying to create a filter for a report in ms project 2013 that shows task that are not complete but are due up to and including 2 weeks. I want it to be a dynamic filter rather than using the date between filter.

I have managed to create date1(today) and date2(+7d) and date3(+14d) which are all calculating correctly and working.

But when i try to create a new filter i get a error message.

I have tried

Field name = %complete
Test= is less than
Value = 100

AND

Field name = Finish
Test= is less than or equal too
Value = Date2 (+7d)

Error is

The entry is not valid. The test value cannot be used with the field for the data you want to find or filter for.

Help... its driving me mad, and i can't figure out what i am missing!