Text Mode to Calculate the difference of Project Actual Start Date and Task Actual Completion Date on Task Report

[jamesmiller-zjd]

I'm looking for help with text mode calculation between Project Actual Start Date and Task Actual Completion Date on a Task report.

[Richard_Le_ · Accepted solution]

Hi James,

The below code should do the trick in a task report:

displayname=Proj Start - Task Comp
textmode=true
valueexpression=WEEKDAYDIFF({project}.{actualStartDate},{actualCompletionDate})
valueformat=HTML

This code will work out the number of weekdays between the project actual start date and the task actual completion date. If you don't want to use weekdays, you could simply replace "WEEKDAYDIFF" with "DATEDIFF" and weekends would be included in the calculation. 

Hope that helps!

Best Regards,

Rich.