Expand my Community achievements bar.

DayDiff between TODAY and Project Planned Start Date

Avatar

Level 2

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?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

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

Avatar

Community Advisor

for a task report it would be:

 

 

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

 

 

 

WEEKDAYDIFF(date2, date1)