Group By Week - Not on a sunday | Community
Skip to main content
sydney_peterson
sydney_peterson
Level 3
May 18, 2023
Question

Group By Week - Not on a sunday

  • May 18, 2023
  • 1 reply
  • 1078 views

Is it possible when grouping a list of tasks by week to control the day that the week begins on? I don't like that it's defaulting to Sunday and want to customize it. 

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

1 reply

The_Real_Melinda_Layten
The_Real_Melinda_Layten
Level 3
May 18, 2023

Do you want to shift the definition of the week or just the displayed date on the grouping?

 

For the latter, you can use a valueexpression in the grouping to ADDDAYS(YourDate, 1) to show Monday instead of Sunday.

    sydney_peterson
    sydney_petersonAuthor
    Level 3
    May 18, 2023

    Thank you! I'm not the best with text mode beyond some basics. 

     

    If this is my grouping in text mode, what would I change to produce that result? Ideally, I want to show every friday instead of Sunday because that aligns better with our commission cycle. 

     

    textmode=true
    group.0.linkedname=direct
    group.0.namekey=Commissionable Date
    group.0.valuefield=Commissionable Date
    group.0.notime=true
    group.0.groupdatesby=WY
    group.0.valueformat=customDateAsWeekString

    Terms & ConditionsAccessibility statement

    Loading footer...