Format elapsed days as # weeks, #days

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

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

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

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