Format elapsed days as # weeks, #days

[micheleb6836350]

Hi, I created a calculated column to calculate the number of days between Planned Completion and Planned Start. Is there anyway to format the result in number of weeks as opposed to number of days. Michele Banks Christus Health

[William--]

I would love to know a valueformat that displays in progressively smaller units of measure like "X Weeks, X Days" but I've had to settle for the below, which would display the value in weeks with a decimal (e.g. "4.5 Weeks") displayname=Actual Duration linkedname=direct namekey=actualduration querysort=actualDurationMinutes textmode=true valueexpression=CONCAT(ROUND(DIV({actualDurationMinutes},60,8,5),1)," Weeks") valuefield=actualDurationMinutes valueformat=compound#M:D viewalias=actualduration William English T-Mobile

[micheleb6836350]

Thanks so much for responding. Unfortunately - it doesn't seem to like the format statement. Each time I try to add valueformat=compound#M:D The system erases it. displayname=Duration in Weeks durationunitfield=durationUnit.value linkedname=direct namekey=duration querysort=durationMinutes textmode=true valueexpression=CONCAT(ROUND(DIV({durationMinutes},60,8,5),1)," Weeks") valuefield=durationMinutes valueformat=compound viewalias=duration Michelle Banks Christus Health

[William--]

Hi Michelle, are you copying/pasting the entire code, or just certain lines? You should be copying/pasting the entire code. Also, what object type are you viewing? This was tested on Projects. William English T-Mobile

[micheleb6836350]

I'm using the Task Duration. Michelle Banks Christus Health

[Sbhuta]

This actually worked for me. Thank you!!