Expand my Community achievements bar.

Check out the upcoming December events for Workfront System Administrators!

Code issue? Calculating days from Issue entry to Project Start date

Avatar

Level 6
I'd like to report on the number of days from request entry to project start. I've started an Issue report and added a calculated column using the code below. I'm not getting an error, but no value is populating this field. Any ideas? displayname=Request to Project Start textmode=true valueexpression=DATEDIFF({entryDate},{resolveProject:actualStartDate}) valueformat=int Catherine Hayes The Channel Company
2 Replies

Avatar

Level 10
Hi Catherine, You were close! :) Try this one: textmode=true valueexpression=WEEKDAYDIFF({entryDate},{resolveProject}.{actualStartDate}) valueformat=customNumberAsString Dagmara Garwell BAKKAVOR LTD

Avatar

Level 6
That worked. Thanks so much! Catherine Hayes The Channel Company