Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
  #2  
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, 14 views)
Reply With Quote
Reply



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 03:34 AM.


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