I'm looking for help with text mode calculation between Project Actual Start Date and Task Actual Completion Date on a Task report.
Solved! Go to Solution.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes