Lead time field of a project in Text Mode

[Nijs_Gold_23]

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.

[Nijs_Gold_23 · Accepted solution]

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

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