Loading...
Quick Links

Reply To: Calculating remaining task duration without considering %complete

Home Forums Discussion Calculating remaining task duration without considering %complete Reply To: Calculating remaining task duration without considering %complete

#392888
Tom Boyle
Guest

TQ,
You’ll want to use the ProjDateDiff function rather than datediff. Placing the following formula in a custom duration field should do the trick:
IIf([Current Date]>[Finish],0,IIf([Current Date]<[Start],[Duration],ProjDateDiff([Current Date],[Finish])))