Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!

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