Expand my Community achievements bar.

SOLVED

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

Avatar

Level 4

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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. 

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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.