Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

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?