Expand my Community achievements bar.

Update Report Grouping "Planned Start Date" by Week of to display on a Monday (currently shows start date as a Sunday).

Avatar

Level 1

In my report I group tasks by Planned Start Date-Week (renamed "Week of"), then by Planned Start Date - Day (renamed "Due Date").

 

By default, the Planned Start Date-Week grouping shows the Week start date as Sunday's date, but I want it to show Monday.

 

I've tried a number of things, but nothing seems to work. Below is my  latest attempt:

 

For example, I have tasks with a planned start date of 4/5/2024. I want the "Week of" Grouping to display "4/1/2024", as that is the Monday of the week in which the week will be done, but right now it shows "3/31/2024".

 

Here is what I've tried that continued to give me just the 3/31/2024:

group.1.valueexpression=ADDDAYS({plannedStartDate},1)
group.1.displayname=Week of
group.1.iscollapsed=true
group.1.groupdatesby=WY
group.1.linkedname=direct
group.1.notime=false

 

When I change the value expression to the following . . . . 

group.1.valueexpression=ADDDAYS({plannedStartDate},2)
group.1.displayname=Week of
group.1.iscollapsed=true
group.1.groupdatesby=WY
group.1.linkedname=direct
group.1.notime=false

 It shows the Week of as 4/7/2024 (the Sunday of the following week).

 

However, still no Monday. How can I get it to show Monday? Can I do that and still group as a week?

 

sjboyd81_2-1712262434299.png

 

Any suggestions?

 

 

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 1

Unfortunately, that didn't work.

I changed ADDDAYS to ADDWEEKDAYS . . . 

group.1.valueexpression=ADDWEEKDAYS({plannedStartDate},1)
group.1.displayname=Week of
group.1.iscollapsed=true
group.1.groupdatesby=WY
group.1.linkedname=direct
group.1.notime=false

but ended up with this (a grouping for each weekday of the week):

sjboyd81_0-1712340856176.png

I also realized I'd removed the "valueformat=atDateAsWeekString", so I added it back, and got it summarized by date, but again, a week out, but still a Sunday.

group.0.displayname=Week of
group.0.groupdatesby=WY
group.0.iscollapsed=true
group.0.linkedname=direct
group.0.notime=false
group.0.valueexpression=ADDWEEKDAYS({plannedStartDate},1)
group.0.valueformat=atDateAsWeekString

 

sjboyd81_0-1712341817143.png

Any other suggestions?