Lead time field of a project in Text Mode | Community
Skip to main content
Srinija_N
Level 7
December 12, 2024
Solved

Lead time field of a project in Text Mode

  • December 12, 2024
  • 1 reply
  • 353 views

Hi All,

 

I am looking for a way to build a text mode field called 'Lead time(days)' to have the difference between today and the Planned start date.

 

Can someone help me on this? Thanks in Advance.

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

I was able to build it myself. Below is the text mode:

 

displayname=Lead time(Days)
textmode=true
valueexpression=WEEKDAYDIFF(($$TODAY), {plannedStartDate})
valueformat=HTML

1 reply

Srinija_N
Srinija_NAuthorAccepted solution
Level 7
December 12, 2024

I was able to build it myself. Below is the text mode:

 

displayname=Lead time(Days)
textmode=true
valueexpression=WEEKDAYDIFF(($$TODAY), {plannedStartDate})
valueformat=HTML