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
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:
For your use case the arguments of the function depends on which status you want to compare you can choose one of these values: