WEEKDAYDIFF Between Native Field and the date of specific task

Question

I spent a few hours combing articles and trying things yesterday and wasn’t able to figure this out. Looking for any help!

I have done WEEKDAYDIFF calculations using dates in the system like issue entry date vs project entry date. This time I want to do a WEEKDAYDIFF between the project entry date and the date of the kickoff task in the project.

I can successfully display the Kickoff date in a report using the following textmode:

listmethod=nested(resolveProject.tasks).liststype=iteratevalueexpression=IF(CONTAINS("Kickoff",{name}),CONCAT({plannedCompletionDate}))valueformat=HTMLWhat I can’t figure out is how to work that kickoff task date into a WEEKDAYDIFF calculation.For reference this is what I use for other WEEKDAYDIFF calculations like the issue entry date vs project entry date.displayname=Request to Project Creationvalueexpression=WEEKDAYDIFF({entryDate},{resolveProject}.{entryDate})valueformat=HTMLMore context: This is in an issue report. I want to show the full lifecycle of a project. I have all the relevant dates showing (issue entry, project entry, project kickoff, project completion, etc) I am just working on WEEKDAYDIFF calculations for each step.

NicholeVargas · Accepted Answer

Your WEEKDAYDIFF calculation would use a similar framework to the kickoff column, so it would look something like this. I used the Kickoff task actual start date as the date but you can swap with planned start date/planned completion date, if needed.

displayname=# of days between project entry and kickoff
listdelimiter=<div>
listmethod=nested(resolveProject.tasks).lists
type=iterate
valueexpression=IF(CONTAINS("Kickoff",{name}),WEEKDAYDIFF({project}.{entryDate},{actualStartDate}))
valueformat=HTML

listmethod=nested(resolveProject.tasks).liststype=iteratevalueexpression=IF(CONTAINS("Kickoff",{name}),WEEKDAYDIFF({project}.{entryDate},{actualStartDate}))valueformat=HTML

ZacharyDe1 · Answer

This worked thank you!

Sign up

Login with SSO

Login to the community

Login with SSO