PRJ4: DateDifference Method Returns Incorrect Values
PSS ID Number: Q136498 Article last modified on 09-18-1995
4.00 | 4.00
WINDOWS | MACINTOSH
| The information in this article applies to: |
| - Microsoft Project for Windows, version 4.0 - Microsoft Project for the Macintosh, version 4.0 |
SYMPTOMS
When you use a resource calendar, if you use the DateDifference method in a Visual Basic procedure, the method returns an incorrect value.
CAUSE
This problem occurs if the following conditions are true:
The base calendar the resource is using has a calendar exception.
-and-
The date range the DateDifference method is using encompasses the calendar exception.
WORKAROUND
To get the DateDifference method to return the correct value, modify the resource calendar so that it has the same exception as the base calendar.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATION
The DateDifference method disregards any calendar exception in the base calendar the resource is using and assumes working time is 8:00 AM-12:00 PM and 1:00 PM-5:00 PM with Saturday and Sunday as nonworking days.
KBCategory: kbprg KBSubcategory:
Additional reference words: 4.00 timetrak
Copyright Microsoft Corporation 1995.
