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
  • 1079 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.

    Madalyn_Destafney
    Community Advisor
    Madalyn_DestafneyCommunity Advisor
    Community Advisor
    May 18, 2023

    Would it work when shown in a chart too or would that only reflect in a report's detail view? Also wondering how exactly would enter in text mode if you have an example snippet!

    If this helped you, please mark correct to help others : )
    sydney_peterson
    sydney_petersonAuthor
    Level 3
    May 22, 2023

    I'm not sure what the text mode is exactly, that is what I was hoping to find out from someone in the community. 

    Terms & ConditionsAccessibility statement

    Loading footer...