How to calculate days past original due date?

Luis Cardenas

One of our product teams is wanting to monitor and report on tasks that are X days past their ORIGINAL assigned due dates

• Given that I have a set of active tasks with due dates
• AND those tasks are OVERDUE (past their ORIGINAL due dates)
• AND new due dates have been assigned
• THEN I'd like to see how many days those tasks are past their ORIGINAL due dates

A solution I've tested is

• Creating a Original Due Date formula field that copies the assigned due date of the task
• Once tasks are assigned their first due dates, duplicate them and copy the Original Due Date field value
• Creating another custom field for Days Past Original Due Date that gives me the days since that day

Not a great solution since:

• duplicates the number of tasks
• does not reflect the original task's current status
• does not reflect the original task's assignee (since duplicating the assignee in the new task would be confusing for work execution)

Any ideas team?

Pietro Poli

Hi @Luis Cardenas,
I have the same situation and we did it this way.

On all tasks we have 3 different custom fields:

1. Due date Original (is the date assigned to a task as first due date)
2. Number of Changes (how many changes we have made in due date)
3. Days Difference (a formula that makes a difference between Due date and Due Date original)

So how does it work:

• I create a task and assign a due date
• Upon creation I check whether the "Due date Original" has a value or not
• If it has no value then I copy the Due Date into "Due date Original" and Add +1 to Number of Changes
• If instead it is already valued I Add +1 to Number of Changes

This way I get only 1 task that has this information:

• Original due date
• Current due date
• Number of times the due date has been changed
• How many days between 2 due dates
• Task status

You have to do it with the API or with Wrike Integrate, you have no way to do it with the current automations present in Wrike.