Text mode, how to count if Planned completion date is same or more than 3 three days than task Entry date?

Hi Mari,

Using the following text mode in a column on your view will count the number of weekdays between the task entry date and planned completion date:

displayname=Days between entry and PC

textmode=true

valueexpression=WEEKDAYDIFF({entryDate},{plannedCompletionDate})

valueformat=HTML

The following text mode will return the text '3 or more days' if the difference between entry and planned completion is greater than or equal to 3, else it will return 'Less than 3 days'

displayname=3 days or more?

textmode=true

valueexpression=IF(WEEKDAYDIFF({entryDate},{plannedCompletionDate})>=3,'3 or more days','Less than 3 days')

valueformat=HTML

Hope that helps!

Best Regards,

Rich.