Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Need Help with Text Mode Grouping on Task Report

Avatar

Level 4

I have a Task Report that has a Text Mode Grouping that groups the Tasks into weeks (Mon-Sun) based on the Travel In date . The problem is when the Travel In date is a Sunday, the Task is grouped into the subsequent week instead of the week (Mon-Sun) it's in.

Is there a way to update this text mode to group Sunday tasks in the correct week?

 

Here is the text mode:
group.0.displayname=Week
group.0.valueexpression=CONCAT(CASE(MONTH(ADDDAYS({DE:Originals | Crew/Producer Travel In},SUM(PROD(DAYOFWEEK({DE:Originals | Crew/Producer Travel In}),-1),2))),'Jan ','Feb ','Mar ','Apr ','May ','Jun ','Jul ','Aug ','Sep ','Oct ','Nov ','Dec '),DAYOFMONTH(ADDDAYS({DE:Originals | Crew/Producer Travel In},SUM(PROD(DAYOFWEEK({DE:Originals | Crew/Producer Travel In}),-1),2))),' - ',CASE(MONTH(ADDDAYS({DE:Originals | Crew/Producer Travel In},SUM(PROD(DAYOFWEEK({DE:Originals | Crew/Producer Travel In}),-1),8))),'Jan ','Feb ','Mar ','Apr ','May ','Jun ','Jul ','Aug ','Sep ','Oct ','Nov ','Dec '),DAYOFMONTH(ADDDAYS({DE:Originals | Crew/Producer Travel In},SUM(PROD(DAYOFWEEK({DE:Originals | Crew/Producer Travel In}),-1),8))))
textmode=true

 

jamesmillerzjd_0-1694445881922.png

 

2 Replies

Avatar

Community Advisor

Do you have your weeks starting default on Monday?

Avatar

Level 4

Where are you referring to? Where would I check this?