Expand my Community achievements bar.

SOLVED

Converted Issue Date to Task Completion Date Difference

Avatar

Level 1

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.

BrittanyB8_0-1716410932803.png

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

View solution in original post

4 Replies

Avatar

Community Advisor

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?

Avatar

Level 1

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

Avatar

Correct answer by
Community Advisor

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.