Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

Week Commencing Grouping in reporting

Avatar

Level 3

I'm trying to group an issue report on the issue entry date by week (as in, the week the issue was entered). The default way of doing this (Groupings > Issue > Entry date and group by week) is almost perfect however because in WF the starting day of the week is a Sunday by default, i'm getting the week grouping date shown in the report to be 1 day earlier than i'd like. Does anyone know of a way using text mode or otherwise to change this? Or is the easiest way to use a calculated field on the entry date and group on that?

 

Report SS 1.PNGReport SS 2.PNG

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

It's true that WF has start day set to Sunday, which isn't ideal and I've confirmed this isn't a setting you can change somewhere. Not sure how to change it with a calculated field. There is an Idea to please upvote to change this here! https://experienceleaguecommunities.adobe.com/t5/workfront-ideas/calendar-to-display-dates-from-mond...

If this helped you, please mark correct to help others : )

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

It's true that WF has start day set to Sunday, which isn't ideal and I've confirmed this isn't a setting you can change somewhere. Not sure how to change it with a calculated field. There is an Idea to please upvote to change this here! https://experienceleaguecommunities.adobe.com/t5/workfront-ideas/calendar-to-display-dates-from-mond...

If this helped you, please mark correct to help others : )