Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-31-2014, 05:38 AM
TCB TCB is offline flag to indicate finish date does not equal baseline finish date Windows 7 32bit flag to indicate finish date does not equal baseline finish date Office 2010 32bit
Novice
flag to indicate finish date does not equal baseline finish date
 
Join Date: Jul 2014
Posts: 3
TCB is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 08-01-2014, 08:41 AM
JulieS JulieS is offline flag to indicate finish date does not equal baseline finish date Windows 7 64bit flag to indicate finish date does not equal baseline finish date Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
  #3  
Old 08-06-2014, 09:17 AM
TCB TCB is offline flag to indicate finish date does not equal baseline finish date Windows 7 32bit flag to indicate finish date does not equal baseline finish date Office 2010 32bit
Novice
flag to indicate finish date does not equal baseline finish date
 
Join Date: Jul 2014
Posts: 3
TCB is on a distinguished road
Default

Thanks so much Julie. You always get me on track.
Reply With Quote
  #4  
Old 08-06-2014, 02:49 PM
JulieS JulieS is offline flag to indicate finish date does not equal baseline finish date Windows 7 64bit flag to indicate finish date does not equal baseline finish date Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You're welcome and thanks for the feedback.
Reply With Quote
Reply

Thread Tools
Display Modes


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
flag to indicate finish date does not equal baseline finish date how to calculate backwards from a set finish date ketanco Project 1 02-07-2013 06:50 AM
flag to indicate finish date does not equal baseline finish date 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft