Expand my Community achievements bar.

The first Coffee Break sweepstakes in the Workfront Community is TOMORROW at 8:30AM PST! Share your Project Template and Timeline best practices or ask a related question for an opportunity to win Workfront swag.
SOLVED

Can you do a datediff between one tasks's planned completion date and another?

Avatar

Level 3

I am trying to do this but it's not working: The business wants to see how often there is between the due date of the previous task versus the current task, and if that's less than 2 days. So I am trying to do a datediff between the predecessor planned completion date and the current task, but its coming up blank. I am sure I have the formatting messed up but I am still learning TEXTMODE.

 

displayname=Task Planned Completion Date Vs Predecessor Planned Completion Date
linkedname=direct
querysort=plannedCompletionDate
textmode=true
valueexpression=ROUND(DATEDIFF(({predecessor}.{plannedCompletionDate}),{plannedCompletionDate}),2)
valueformat=HTML

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Checking the API explorer, there's no reference for predecessor, so predecessor.plannedCompletionDate shouldn't work. But nice guess.

 

(i.e. go to the API explorer and look up TASK and then look in the Reference tab for everything that can be a reference (a "reference" is what you've done above). e.g. Project is listed as a reference, so {project}.{plannedCompletionDate} would be a sure thing... too bad you don't want that one.)

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Checking the API explorer, there's no reference for predecessor, so predecessor.plannedCompletionDate shouldn't work. But nice guess.

 

(i.e. go to the API explorer and look up TASK and then look in the Reference tab for everything that can be a reference (a "reference" is what you've done above). e.g. Project is listed as a reference, so {project}.{plannedCompletionDate} would be a sure thing... too bad you don't want that one.)