I have an urgent qs. I have a task with duration as 10 days. I need to calculate the remaining duration (without taking into account) percent completion as days pass by. For eg : task1 starts on 1st april and ends on 10th april and has a duration of 10 days. Now i want to create a custome field which will show me the remaining duration on 2nd april as 9days. Please guide. Thanks
Actually larry i did, but its not giving me the desired result. I tried using the datediff function with Current date and Finish date as variables but that too didnt work. A little help here would really be appreciated.
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])))