DDIFF between task 1 change to completed date and task 2 changed to in progress date

Hello, 

I am trying to calculate the days between one tasks status change to "completed" and another tasks status change to "in progress" I keep getting an [ token error on the formula I created. 

Anyone have any ideas? 

DDIFF ([TASK NAME] [TASK STATUS CHANGE HISTORY NEW STATUS], [TASK NAME] [TASK STATUS CHANGE HISTORY NEW STATUS])

I used filters on task name and task status change to new. 

Days between status changed to completed on project booking and status change to in progress on procurement

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
1 commento

Hi Audrey Cash,
DDIFF allow you to compare dates.

You error should be something like this

You get it because you've two parameters as <Start Time>

So you need to write something like that to compare 2 dates:

DDiff([Days in Task Creation Date],[Days in Task Completion Date])


For your use case the arguments of the function depends on which status you want to compare you can choose one of these values:

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: DDIFF between task 1 change to completed date and task 2 changed to in progress date
[this list is visible for admins and agents only]

Su
Didn’t find what you were looking for? Write new post