Microsoft KB Archive/113743

= PRJ: Custom Filter, Macro to Find Tasks Due "Today" =

Article ID: 113743

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Project 98 Standard Edition
 * Microsoft Project 4.1 Standard Edition
 * Microsoft Project 4.1a
 * Microsoft Project 3.0 Standard Edition
 * Microsoft Project 3.0a
 * Microsoft Project 4.0 Standard Edition
 * Microsoft Project 3.0 for Macintosh
 * Microsoft Project 4.0 for Macintosh

-



This article was previously published under Q113743



SUMMARY
In Microsoft Project, you cannot create a filter that will consistently display tasks that occur on the current date. However, you can a create a custom filter and macro to achieve this result.



MORE INFORMATION
The filter should be entered as follows and named "Today" :

Filter
  Field Name    Test      Value                     And/Or Start        Equals    "enter today's date"? NOTE: If you are using Microsoft Project 3.0, change the field name Start to Scheduled Start.

Microsoft Project 4.0, 4.1, 98
Microsoft provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. This Visual Basic procedure is provided 'as is' and Microsoft does not guarantee that it can be used in all situations. Microsoft does not support modifications of this procedure to suit customer requirements for a particular purpose. Sub Current_Date FilterApply Name:="Today", Value1:="Today" End Sub

Microsoft Project 3.0
Filter .Name=[Today] .Value1=[today]

Additional query words: 3.00a projwin

Keywords: kbcode kbhowto kbmacro KB113743

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.