View Single Post
 
Old 07-10-2015, 06:19 AM
JulieS JulieS is offline Windows 7 64bit Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You'll need to calculate the extra date field to show today + 5 days.
Add a custom Date field (Date1)
Customize the field with the following formula:
DateAdd("d", 5, [Current Date])

That will calculate a date 5 calendar days from the current date.

You can then create your filter:

Field: Scheduled finish
Test: is less than
Values: [Date1]

As in the original, you may also want to test if the task is already complete.
Reply With Quote