I see a filter to show which milestones are due this month ("End of the month is:"?) but not modify that so that it shows milestones due within 2 months.

Greatly appreciate your help

Have you tried using the Autofilters on the Finish field? Add the Milestone Field to the table - filter for milestones = Yes. Then click the AutoFilter drop-down on the finish field, and select which months you wish to see.

Attached Images

	finish.jpg (49.5 KB, 29 views)
	Milestone.jpg (71.9 KB, 29 views)

thanks for the reply, but applies to the gantt chart and not the report, right?

What report are you using? What release of Project?

Project 13 Standard, a modified version of project overview

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

Milestones filter.jpg (82.8 KB, 35 views)

AWESOME!! thanks so much it worked.

You're welcome and thanks for the feedback.