DayDiff between TODAY and Project Planned Start Date

[ThomasNe2]

I am trying to amend a report of Tasks that will pull a field to show the difference in days between Today ($$TODAY) and Project Planned Start Date.

Can anyone help me with the Text Mode for the report or a calculated field?

[ThomasNe2 · Accepted solution]

WEEKDAYDIFF($$TODAY,{project}.{plannedStartDate})

[KellieGardner]

for a task report it would be:

displayname=Week Day Difference
valueexpression=WEEKDAYDIFF($$TODAY,{project}.{plannedStartDate})
valueformat=HTML

WEEKDAYDIFF(date2, date1)