I've created a 2 Week Look Ahead filter that identifies those tasks that will or are being worked in the next 2 weeks.

I've started by creating a custom date field (2WL) that is a formula (Current date + 14).

My filter is:


(Field Name) Scheduled Start (Test) is less than or equal to (Value) 2WL.

The result of this filter displays those individual tasks that have a scheduled start date equal to or less than 2 weeks from today. Unfortunately it also displays Summary Level tasks (but not the detail tasks) whose work begins beyond the 2 week window.

When I edit my formula to:
(Field Name) Scheduled Start (Test) is less than or equal to (Value) 03/17/16
It gives me the result I'm looking for - no summary tasks.

Any thoughts on how I can make this filter work with no summary tasks and not requiring editing the date each time?

Note:I've attached 2 images showing the results. Also my filter includes several other lines relating to % complete and active tasks. These lines have no bearing on the results.

Attached Images

	With Summary.png (52.7 KB, 20 views)
	Without Summary.png (35.9 KB, 17 views)