#1
|
|||
|
|||
Project Reports Overview Milestone Filter
I'm trying to create a filter for the Milestones Due that is part of the Project Overview report. I want the filter to only look at milestones due in the next 14 days.
I've created a custom date that is equal to today + 14. It is called 2 Week Look. When I attempt to use this field as a value in my filter (Finish / Is Less Than Or Equal To / 2 Week Look) I receive an error: The entry is not valid. The test value cannot be used with the field for the data you want to find or filter for. Any help as to why I'm receiving this error and if there's a way to create this filter is greatly appreciated! |
#2
|
|||
|
|||
It looks like the finish field is a text field and not a date field? When I create my 2 week look custom field as a text field I no longer get the error - however I still don't get the result I'm looking for.
|
#3
|
|||
|
|||
Are you looking at Finish or Scheduled Finish? The Finish field may be text - the scheduled finish field is a date.
When you say you don't get the result - what is happening? Too much time? Too little time? Please post for formula for the 2 Week Look. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
MS Project 2013 - Overview report error | Imagios | Project | 15 | 02-05-2016 09:21 AM |
How to show planned% complete and actual% complete on the (Project Overview) dashboard report? | zislam14 | Project | 3 | 12-17-2015 03:03 PM |
After open Project Overview Dashobard report, its blank | anurag9179 | Project | 3 | 01-15-2015 06:57 AM |
Project 2010 - Milestone Font Colour | OTPM | Project | 1 | 05-11-2011 03:22 AM |
running reports out of ms project | nmanus | Office | 0 | 09-09-2009 12:47 PM |