Converting Project Duration from days to weeks | Community
Skip to main content
Level 3
June 9, 2020
Question

Converting Project Duration from days to weeks

  • June 9, 2020
  • 1 reply
  • 543 views

I would like to create a calculated field to convert the project duration field from days into weeks? Any help will be appreciated.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

SbhutaAuthor
Level 3
June 9, 2020

Please close this request. I found the answer below from one of the posts:

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