I revised the original post. so it doesn’t make sense below.
I recognized this post is wrong.
“specific due date” changes day by day.
To avoid that, we need to append a date custom field for dummy in projects and portfolios.
I’ll revise this post later.but I write a summary below;
- Append a date custom field named “dummy date” to both projects and portfolios
- Set any date as you like to “dummy date” for the specific task.But you need to set the same date in a portfolio.
- Change the definition of “due date - today” to (Due date - dummy date)/1440+0
- Change the name of “due date - today” to “due date - dummy date”
- Change the name of “due date - today2” to “due date -dummy date2”
- Change the definition of “specific due date” to DateAdd(dummy date,Rollup(due date - dummy date2))