View: calculate time and date differences

Go to a list of tasks.

From the View drop-down menu, click New View.

Click Add Column and start typing “Planned Completion Date” in the Show in this column field then select it when it displays in the list.

Click Add Column and start typing “Actual Completion Date” in the Show in this column field then select it when it displays in the list.

Click Add Column, then click Switch to Text Mode.

Hover over the text mode area, and click Click to edit text.

Remove the text you find in the Text Mode box, and replace it with the following code:

 displayname=Planned-Actual Completion Date
 linkedname=direct
 querysort=plannedCompletionDate
 textmode=true
 valueexpression=ROUND(DATEDIFF({plannedCompletionDate},{actualCompletionDate}),2)
 valueformat=HTML

Click Save, then Save View.

Go to a list of tasks.

From the View drop-down menu, click New View.

Click Add Column and start typing " Project Planned Completion Date" or “Parent Completion Date” in the Show in this column field then select it when it displays in the list.

Click Add Column and start typing “Planned Completion Date” in the Show in this column field then select it when it displays in the list.

Click Add Column, then click Switch to Text Mode > Edit Text Mode.

Remove the text you find in the Edit Text Mode box, and replace it with one of the following codes:

• To display the difference between the Planned Completion Date of the project and that of the task:

   displayname=Project Planned Completion - Task Planned Completion (Days)
   textmode=true
   valueexpression=ROUND(DATEDIFF({project}.{plannedCompletionDate},{plannedCompletionDate}),2)
   valueformat=HTML
  

• To display the difference between the Planned Completion Date of the parent task and that of the task:

   valueexpression=ROUND(DATEDIFF({parent}.{plannedCompletionDate},{plannedCompletionDate}),2)
   textmode=true<br>valueformat=HTML
   displayname=Parent Planned Completion - Planned Completion (Days)
  

Click Done, then Save View.