PRJ98: Tasks Using Time Format Not Filter w/AutoFilter (173330)
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
This article was previously published under Q173330 SYMPTOMS
In Microsoft Project 98, when you use the AutoFilter tool, one or more tasks may not appear in the results list.
This problem occurs if you filter the tasks using a date criterion and the time you specified in the task includes seconds. For example, if you have a task that has the following start time
and you apply a filter using a date format that does not specify seconds, like this
the task will not appear in the filtered results.
CAUSE
This problem occurs when you use filter criterion that does not use seconds and your data is formatted using a date format that specifies seconds. However, Microsoft Project assumes that you want to filter based on seconds when you specify a date format that includes the time even though you did not enter a value for seconds in the filter criterion. Therefore, in the example shown in the "Symptoms" section, the AutoFilter tool is using the following filter:
WORKAROUND
To work around this problem, use either of the following methods:
Method 1: Use a date format that does not display time- On the Tools menu, click Options.
- Click the View tab.
- In the Date Format list, select a date format that does not
include time, such as "8/27/97."
- Click OK.
Method 2: Re-enter the dates for the tasks
Re-enter the dates for the tasks, but do not specify seconds. Microsoft Project will assume that the time uses by the tasks will be set at zero seconds.
STATUS
Microsoft has confirmed this to be a problem in the versions of Microsoft
Project listed above.
| Modification Type: | Major | Last Reviewed: | 11/25/2003 |
|---|
| Keywords: | kbbug kbpending kbusage KB173330 |
|---|
|