View Single Post
 
Old 08-01-2014, 08:41 AM
JulieS JulieS is offline Windows 7 64bit 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