Lead time field of a project in Text Mode | Community
Skip to main content
Srinija_N
Level 7
Dec 12, 2024 11:56 AM UTC
Solved

Lead time field of a project in Text Mode

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.
Srinija_N
Srinija_NAccepted solution
Level 7
Dec 12, 2024 4:25 PM UTC

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
Dec 12, 2024 4:25 PM UTC

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

 

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

Translate