Converted Issue Date to Task Completion Date Difference | Community
Skip to main content
B
BrittanyB8
Level 3
May 22, 2024
Solved

Converted Issue Date to Task Completion Date Difference

  • May 22, 2024
  • 1 reply
  • 949 views

I have seen a few older posts about this but it is not working on a report I am doing. It is in a task report and is filtered to look at a specific task completion. I have tried custom column:
displayname=Submission to CCB Decision Turnaround Time
textmode=true
valueexpression=WEEKDAYDIFF({convertedOpTaskEntryDate},{actualCompletionDate})
valueformat=HTML

and a calculated field:

WEEKDAYDIFF({convertedOpTaskEntryDate},{actualCompletionDate})

Neither is pulling any data. Any help or suggestions appreciated.

 

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 skyehansen

when you're in a task report and calling out information from the project, always tack on that location. So with the fields I mentioned above, you'll get workfront calculating a difference between a task's actual completion date (we didn't have to mention "task" because it's a task report) and its project originating issue entry date.

1 reply

skyehansen
Community Advisor
skyehansenCommunity Advisor
May 22, 2024

I like your screenshot. You mentioned the converted optask entry date, but what you don't mention is that the optask was converted to a project. If that's the case, I would think you would be looking at a date diff between {project}.{convertedOpTaskEntryDate} and {actualCompletionDate}. Can you clarify if that's what's going on?

B
BrittanyB8Author
Level 3
May 22, 2024

Oh yes. Good call out. These were converted into projects.

skyehansen
Community Advisor
skyehansenCommunity AdvisorAccepted solution
May 22, 2024

when you're in a task report and calling out information from the project, always tack on that location. So with the fields I mentioned above, you'll get workfront calculating a difference between a task's actual completion date (we didn't have to mention "task" because it's a task report) and its project originating issue entry date.

Terms & ConditionsAccessibility statement

Loading footer...