PRJ: Custom Filter, Macro to Find Tasks Due "Today" (113743)


The information in this article applies to:

  • Microsoft Project 98 for Windows
  • Microsoft Project for Windows 95 4.1
  • Microsoft Project for Windows 95 4.1a
  • Microsoft Project for Windows 3.0
  • Microsoft Project for Windows 3.0a
  • Microsoft Project for Windows 4.0
  • Microsoft Project for the Macintosh 3.0
  • Microsoft Project for the Macintosh 4.0
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]
Modification Type:MajorLast Reviewed:11/25/2003
Keywords:kbcode kbhowto kbmacro KB113743
©2003 Microsoft Corporation. All rights reserved.