View Single Post
 
Old 08-13-2014, 02:50 PM
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

The usual Project Overview report shows all milestones in the Milestones table that are not complete. Are you referring to that table?

You can create a custom filter to show milestones that are 60 days to today. You'll first need to calculate the value for X days from the current date.

Add a date field to the Gantt chart view. For this example, I used the [Date1] field.
Customize the field with the following formula:
ProjDateAdd([Current date], 60 * [Minutes per Day])

That will show you the date 60 days from the current date - so if today's date is August 13, I am seeing Nov 4. Adjust the increment (60) as needed to get the values you seek.

Then create a custom filter - look at the attachment for the filter definition.

In the Project Overview report - in the Milestones table - select the filter you created.
Attached Images
File Type: jpg Milestones filter.jpg (82.8 KB, 38 views)
Reply With Quote