View Single Post
 
Old 07-31-2014, 05:38 AM
TCB TCB is offline Windows 7 32bit Office 2010 32bit
Novice
 
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