I am using project server, I've tried to subtract start date and finish date in custom field formula using DateDiff to calculate the duration.

I noticed the wired output is not identical to the build in duration field in project server !!!

What I did wrong ?! I'd appreciate any help.

1 Answer 1


Project server defines the duration as

The total span for working time for a task or project

The working time here depend on the current project server calendar settings.

So if you configured your calendar to have two days as weekends let's say Saturday & Sunday with 8 hours per day and you have a task that starts on Saturday and ends on Tuesday so the duration should be 2 days as working time and not 4 days.

So regarding your issue if you tried to use DateDiff function you will get the difference between the end date and start date that based on my above example is should be 4 not 2 like duration field value.

But if you need to calculate only working time depending on your calendar setting so in this case, you should use ProjDateDiff( date1, date2, calendar ) instead of DateDiff.

the ProjDateDiff will calculate the date difference between two dates based on the project server calendar settings.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.