Is there a way to report number of days difference on a task approval start date compared to the project planned completion Date?

Hi Dan!

You have 2 options. If you just want to see the column with the number on a task report, you can set up a column with the following formula:

------------

displayname=Weekday Diff

textmode=true

valueexpression=WEEKDAYDIFF({approvalStartDate},{project}.{plannedCompletionDate})

valueformat=HTML

------------

OR if you need calendar days:

------------

displayname=Calendar Diff

textmode=true

valueexpression=DATEDIFF({project}.{plannedCompletionDate},{approvalStartDate})

valueformat=HTML

------------

The downside to a "valueexpression" like this is that the value isn't groupable, sortable, or chartable. So if you want to do any of those things, your only option would be to create a custom form for tasks, attach it to the tasks (probably best to do it at the template level so it doesn't require ongoing maintenance). Then you'd add a calculated field to the form, that uses the following formula:

WEEKDAYDIFF(Approval Start Date,Project.Planned Completion Date)

OR for calendar days:

DATEDIFF(Project.Planned Completion Date,Approval Start Date)