#1
|
|||
|
|||
flag to indicate finish date does not equal baseline finish date
Can someone direct me on how to set a flag to indicate that a finish date is not equal to the baseline finish date.
I have entered in the following formula in the custom fields form: [Finish]<>[Baseline Finish] However, if the finish date is say 9/3/14 and the baseline finish is 9/3/14 I may still get a finish does not equal baseline finish do to the finish date may actually be 9/3/14 2:30pm and the baseline finish date may be 9/3/14 1:30 pm. I am not concerned about the time of day, I just want to know if the 9/3/14 start is different from the baseline start. Is there a way to write a formula that says check date and ignore the time? If not is there any other way to accomplish this? I am using MS Project Standard 2010 (32-bit)non server with SP2 installed. I am running Microsoft Windows 7 Enterprise. Thanks for you help. |
#2
|
|||
|
|||
Have you considered setting deadlines on key tasks? Deadlines are always as of the default end time of a day. So, in your scenario above the task would still be meeting the deadline (although there is finish variance). Tasks are flagged in the indicator column if you are scheduled to miss a deadline.
If you wish to test variance for every task, the formula below should work: In a Flag field: DateValue([Baseline Finish])-DateValue([Finish])>=1 will show "yes" for any task that does not have the same date value finish as the date value baseline finish. |
#3
|
|||
|
|||
Thanks so much Julie. You always get me on track.
|
#4
|
|||
|
|||
You're welcome and thanks for the feedback.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Assigning finish date to work with %complete | Guloluseus | Project | 3 | 12-12-2013 10:16 AM |
how to calculate backwards from a set finish date | ketanco | Project | 1 | 02-07-2013 06:50 AM |
Units not properly updated after a Finish Date Change | zi1 | Project | 1 | 08-04-2012 05:55 AM |
remaining duration vs finish date | ketanco | Project | 3 | 02-17-2012 02:24 PM |
MS Project able to import actual start and or actual finish date from Excel? | mhacker | Project | 0 | 04-26-2010 11:29 AM |