none
Microsoft Project 2010 & 2013: Application.DateDifference and Application.DurationFormat RRS feed

  • Question

  • I seem to remember these methods accepting negative duration values in the past, but now they breakdown completely. A negative value passed to DurationFormat results in an error, and if the DateDifference is performed on a Start date greater than the Finish date, it results in 0 (as opposed to the true negative answer). Is this true for anyone else, or is there an application setting somewhere that I need to toggle?

    This is for a network analysis tool that calculates true 'free float' between task dependencies using DateDifference, but I need to be able to account for leads/negative lags, etc and then display the value back to the user using DurationFormat. Has anyone else encountered this, or a similar, issue?

    Saturday, August 1, 2015 2:14 PM

All replies