Text Mode to Calculate the difference of Project Actual Start Date and Task Actual Completion Date on Task Report | Community
Skip to main content
JamesM-MERGE
JamesM-MERGE
Level 4
March 8, 2023
Solved

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

  • March 8, 2023
  • 1 reply
  • 758 views

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Richard_Le_

    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. 

    1 reply

    R
    Community Advisor
    Richard_Le_Community AdvisorAccepted solution
    Community Advisor
    March 8, 2023

    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. 

    Terms & ConditionsAccessibility statement

    Loading footer...