Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-31-2014, 02:06 PM
bypm bypm is offline Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Windows 7 32bit Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Office 2010 32bit
Novice
Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks
 
Join Date: Jan 2014
Posts: 2
bypm is on a distinguished road
Default Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks

Hi,

I have had a search but couldn't find the answer.

I am trying to create a filter for a report in ms project 2013 that shows task that are not complete but are due up to and including 2 weeks. I want it to be a dynamic filter rather than using the date between filter.

I have managed to create date1(today) and date2(+7d) and date3(+14d) which are all calculating correctly and working.

But when i try to create a new filter i get a error message.

I have tried

Field name = %complete
Test= is less than
Value = 100

AND

Field name = Finish


Test= is less than or equal too
Value = Date2 (+7d)

Error is

The entry is not valid. The test value cannot be used with the field for the data you want to find or filter for.

Help... its driving me mad, and i can't figure out what i am missing!
Reply With Quote
  #2  
Old 01-31-2014, 02:41 PM
JulieS JulieS is offline Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Windows 7 64bit Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Use Scheduled Finish instead of Finish. The Finish field will accept text entries for manually scheduled task.
Reply With Quote
  #3  
Old 01-31-2014, 02:47 PM
bypm bypm is offline Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Windows 7 32bit Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Office 2010 32bit
Novice
Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks
 
Join Date: Jan 2014
Posts: 2
bypm is on a distinguished road
Default

JulieS thank you so much... sometimes the obvious is the hardest to see!

Loving this forum, glad i stubbled across it!
Reply With Quote
  #4  
Old 01-31-2014, 03:09 PM
JulieS JulieS is offline Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Windows 7 64bit Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Great. Glad you have it sorted and thanks for the feedback.
Reply With Quote
  #5  
Old 07-10-2015, 01:54 AM
garthbond garthbond is offline Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Windows 8 Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Office 2013
Novice
 
Join Date: Jul 2015
Location: Johannesburg, South Africa
Posts: 2
garthbond is on a distinguished road
Default Please assist with this issue

Quote:
Originally Posted by bypm View Post
JulieS thank you so much... sometimes the obvious is the hardest to see!

Loving this forum, glad i stubbled across it!
Hi there,

Isee you managed to resolve this issue however, I'm still trying to create a filter for the next week's tasks and struggling to do this.

Can you please share what you did and the final filter details you used to resolve this?

Please advise

Regards
Garth
Reply With Quote
  #6  
Old 07-10-2015, 05:51 AM
JulieS JulieS is offline Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Windows 7 64bit Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Let's start with some more information from you:

What release of MS Project are you using?
What have you tried and specifically what has not worked?

Have you looked at the built-in filter - such as Date Range or Tasks Starting soon?
Reply With Quote
  #7  
Old 07-10-2015, 05:58 AM
garthbond garthbond is offline Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Windows 8 Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Office 2013
Novice
 
Join Date: Jul 2015
Location: Johannesburg, South Africa
Posts: 2
garthbond is on a distinguished road
Default

Using MS Project 2013.

Seems like the Date Range does work. What I was trying to do is create a new filter, so that it takes today's date and then filters the tasks due in the next 5-days. SO it's a simple quick click.

If not possible, i will use the Date Range.

Regards
Garth
Reply With Quote
  #8  
Old 07-10-2015, 06:19 AM
JulieS JulieS is offline Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Windows 7 64bit Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks 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
Reply

Tags
dynamic date filter, ms project

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks MS Project 2013 - Overview report error Imagios Project 15 02-05-2016 09:21 AM
Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Who Does What When report in Project 2013 Smithy15 Project 1 01-20-2014 08:48 AM
Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Creating Report based on 'Task Summary' and 'Sub Tasks' alijahed Project 1 02-01-2013 04:20 AM
Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Summary Report for Individual Task tmanzan Project 7 01-15-2013 12:45 PM
Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks Newbie in Office Project wajebwahab Project 5 04-14-2010 01:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:17 AM.


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