Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-13-2011, 02:47 PM
stct stct is offline Dynamic Filter 15 days lookout. Windows XP Dynamic Filter 15 days lookout. Office 2003
Novice
Dynamic Filter 15 days lookout.
 
Join Date: May 2011
Posts: 12
stct is on a distinguished road
Default Dynamic Filter 15 days lookout.

Hi all,

I am trying to define a custom filter with following parameters in Resource Usage view:
1. Display Not Completed tasks (%Work Complete <> 100%)
2. Start < [Today + 15 days] OR Basline Start < [Today + 15 days]

I first defined custom date fields to capture Today + 15 days. Then added a Custom filter with above formula..

Results: unfortunately, this showed me tasks with Start and Baseline start date 3 months out..

Can anyone suggest a better way of getting this so that correct data is displayed. Option to avoid customization would help, if possible to define.




Thank you in advance,
Reply With Quote
  #2  
Old 05-17-2011, 07:16 AM
OTPM OTPM is offline Dynamic Filter 15 days lookout. Windows 7 32bit Dynamic Filter 15 days lookout. Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi sctc
You dont have to create any filter. On the formatting toolbar simply select the Date range... option. You will be asked for a Start Date and then it will ask you for an End Date. Just set the End Date to 15 days hence and this will give you what you want.
Good luck.
Tony
Reply With Quote
  #3  
Old 05-17-2011, 08:09 AM
stct stct is offline Dynamic Filter 15 days lookout. Windows XP Dynamic Filter 15 days lookout. Office 2003
Novice
Dynamic Filter 15 days lookout.
 
Join Date: May 2011
Posts: 12
stct is on a distinguished road
Smile

Thanks Tony, for the reply!

1. I am trying to automate so that I donot have to enter dates every time I run a filter on a weekly basis.

2. Unfortunately, there are 2 different fields (Baseline Finish OR Finish). If I use field filter, it may not give me tasks which meet both the parameters with an 'OR' condition.

Hope this helps on the need. Pls advise,

Best Regards,

Chetan.
Reply With Quote
  #4  
Old 05-17-2011, 02:54 PM
OTPM OTPM is offline Dynamic Filter 15 days lookout. Windows 7 32bit Dynamic Filter 15 days lookout. Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Quote:
Originally Posted by stct View Post
Thanks Tony, for the reply!

1. I am trying to automate so that I donot have to enter dates every time I run a filter on a weekly basis.

2. Unfortunately, there are 2 different fields (Baseline Finish OR Finish). If I use field filter, it may not give me tasks which meet both the parameters with an 'OR' condition.

Hope this helps on the need. Pls advise,

Best Regards,

Chetan.
Hi Chetan
I have put a formula in the Flag1 field (check it out).
I have also created a custom filter called 15 Day Lookout.
Just apply the filter.
I think this is what you want.
Good luck.
Tony
Attached Files
File Type: zip 15 Day Lookout Plan.zip (151.5 KB, 12 views)
Reply With Quote
  #5  
Old 05-19-2011, 09:38 AM
stct stct is offline Dynamic Filter 15 days lookout. Windows XP Dynamic Filter 15 days lookout. Office 2003
Novice
Dynamic Filter 15 days lookout.
 
Join Date: May 2011
Posts: 12
stct is on a distinguished road
Default

Thanks Tony! Unfortunately, I am unable to open the file - version conflict. Do you have this in 2007 MSP version by any chance? I am parallely checking on installing convertor.
Reply With Quote
  #6  
Old 05-20-2011, 03:30 AM
OTPM OTPM is offline Dynamic Filter 15 days lookout. Windows 7 32bit Dynamic Filter 15 days lookout. Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Chetan

The file IS in MSP2007. Is it Winzip you cannot open? If so you can download an uptodate free evaluation copy of Winzip.
Let me know.

Tony
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Filter 15 days lookout. Non-Working Days on Gantt JayTT Project 1 01-28-2011 05:42 AM
Dynamic Filter 15 days lookout. Dynamic footer WalterinOz Word 1 12-22-2010 11:08 PM
Conditional formatting of Today +21 days? SHERMAN Excel 3 12-20-2010 08:08 AM
Creating an Auto-Calc'd Date? Today+7 Days? SoCalTelephone Word 0 10-06-2010 10:27 AM
Outlook Calendar continually resets days in Day View tecsi Outlook 0 08-11-2010 06:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:15 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