Need Help with Text Mode Grouping on Task Report | Community
Skip to main content
JamesM-MERGE
Level 4
September 11, 2023
Question

Need Help with Text Mode Grouping on Task Report

  • September 11, 2023
  • 1 reply
  • 566 views

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

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

RandyRoberts
Community Advisor
Community Advisor
September 12, 2023

Do you have your weeks starting default on Monday?

JamesM-MERGE
Level 4
September 12, 2023

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