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?

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 ThomasNe2

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

ThomasNe2AuthorAccepted solution

Level 4

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