Solved

DayDiff between TODAY and Project Planned Start Date

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?

Best answer by ThomasNe2

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

ThomasNe2AuthorAccepted solution

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

Community Advisor

for a task report it would be:

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

WEEKDAYDIFF(date2, date1)

Sign up