Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-03-2015, 02:38 PM
ebilbrough ebilbrough is offline Project Reports Overview Milestone Filter Windows 10 Project Reports Overview Milestone Filter Office 2013
Novice
Project Reports Overview Milestone Filter
 
Join Date: Nov 2015
Location: Austin, TX
Posts: 19
ebilbrough is on a distinguished road
Default 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!
Reply With Quote
  #2  
Old 12-03-2015, 02:53 PM
ebilbrough ebilbrough is offline Project Reports Overview Milestone Filter Windows 10 Project Reports Overview Milestone Filter Office 2013
Novice
Project Reports Overview Milestone Filter
 
Join Date: Nov 2015
Location: Austin, TX
Posts: 19
ebilbrough is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 12-17-2015, 03:07 PM
JulieS JulieS is offline Project Reports Overview Milestone Filter Windows 7 64bit Project Reports Overview Milestone Filter Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Project Reports Overview Milestone Filter MS Project 2013 - Overview report error Imagios Project 15 02-05-2016 09:21 AM
Project Reports Overview Milestone Filter 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft