Expand my Community achievements bar.

The Community Advisors application is now OPEN for the second class of 2024. Apply to become a part of this exclusive program!

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