Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!

Difference between actual start and actual completion date of task

Avatar

Level 1

Hi,

 

I am trying to see the no of days between a task's actual completion vs actual start. I wrote the query like this. But it is not giving me any result.

displayname=Difference
textmode=true
valueexpression=WEEKDAYDIFF({actualCompletionDate},{actualStartDate}) valueformat=HTML

1 Reply

Avatar

Level 2

Were you able to get this resolved?  I'm trying to do the same thing.  I am looking to have a column that will give me the number of days and time between the actual start date of a task and the actual completion date.  Text mode and I don't get along all the time so if someone has the actual code i can copy and paste that would be amaizing.