Project Report: Task Collection Text Mode for tasks planned in the next 2 weeks

[MoniqueEvans]

Hi Community! Hoping someone can put me out of my misery and help me tweak my text mode code.

I have a project report want to include a column that is a task collection; however, I only want to show tasks (not parents) planned for the next 10 days (2 weeks) and aren't yet completed. Below is the current text mode that works, but it shows all tasks not completed and I need to add in a "< Today + 10d" qualifier

displayname=Tasks Due in Next 2 Weeks
listdelimiter=<p>
listmethod=nested(tasks).lists
textmode=true
type=iterate
usewidths=true
valueexpression=IF({numberOfChildren}=0,IF(ISBLANK({actualCompletionDate}),CONCAT({plannedCompletionDate}," - ",{name})))
valueformat=HTML
width=300

[KatherineLa]

Give this edit a try. That will also give you overdue tasks in the past as well as it's written, FYI.

valueexpression=IF({numberOfChildren}=0,IF({plannedCompletionDate}<$$TODAY+10d,IF(ISBLANK({actualCompletionDate}),CONCAT({plannedCompletionDate}," - ",{name}))))

[Sujatha_TS]

Hi Moni, I might be wrong.

My understanding is this might need another valueexpression for planned completion date adddays formula with $$today to +10 days. However, when I tried one valueexpression mode replaced with other showing either dates or task names. 

Here is what I tried - I used the task name valueexpression formula above and used a filter for planned completion date between $$TODAY to $TODAY+10d. 

I would love to see if there is an alternate option. 

Regards, Sujatha 

[Sven-iX · Accepted solution]

Hi @MoniqueEvans 

you're so close! 

Here's the text mode value expression: 

valueexpression=IF({numberOfChildren}=0 && ISBLANK({actualCompletionDate}) && DATEDIFF({plannedCompletionDate}, $$TODAY)<11,CONCAT({plannedCompletionDate}," - ",{name}),"")

Translated: Show the task if 

• it's not a parent
• has no actual completion date
• it's planned completion date is less than 11 days from NOW

[MoniqueEvans]

I appreciate you SO MUCH!!!

I tried so many equations and DATEDIFF never came to mind.