TeamDesk Knowledge Base & Support

basenine 5/24/2013 6:42:53 PM

Your best bet is to create a Formula date Column (Lets say, [DayOfWeek]) which will give you a start day in the week:

PrevDayOfWeek([Date Column],1) should give you a start day of Monday.

Sunday = 0, Monday = 1, Tuesday = 2… So put a # between 0 & 7 after the column in the formula.

All dates in [Date Column] will calculate to, in the formula above's case, to Monday of that week..

So the [Date Column] is set to either 25/5/2013, 24/5/2013, 23/5/2013… etc and the [DayOfWeek] column will return 20/5/2013.

You can then group all records by the [DayOfWeek] column as they have an equal value.

Cheers

ps - the [DayOfWeek] column can be hidden on the record after testing

basenine 5/24/2013 6:43:45 PM

****So put a # between 0 & 7 after the column in the formula.

column was supposed to be comma

Blake Cabot 5/27/2013 6:13:35 AM

Still think grouping by week would be easier rather than a calculated field for every report.... given they have Day, Month, Quarter and Year.

basenine 5/27/2013 6:22:49 AM

Quite true. Hope the formula was able to get you out of that spot of bother in the meantime. ;)

Kirill Bondar  Staff  5/27/2013 6:28:59 AM

The only problem at the moment is that the definition of week is country-specific - it can start on Saturday, Sunday on Monday. And now the question is - should we use user's culture or application culture to define a week's date range? If we'll take user's culture, different users may end up with different results while looking at the same view. If we'll take application culture the user may end up with results she does not expect to see.

Jeff Aibel 5/12/2017 8:38:07 AM

Please add Days and Weeks to the grouping option function.

For many things like tasks and/or scheduling, Days and Weeks are more meaningful than Months or Years.

While I know how to do a work around, this comes up sufficiently often that I think it should be a standard selection criteria in the Grouping Function.

Kirill Bondar  Staff  6/13/2017 6:03:03 AM

Week is defined based on Country property of the database

Kirill Bondar  Staff  6/13/2017 6:04:57 AM

Grouping by week is added - week is defined based on Country property of the database. For Date columns "group by equal values" means "group by days".

Kirill Bondar  Staff  6/13/2017 6:05:35 AM

Merged with:
1106 - Grouping Function Needs additional options

basenine 2/21/2024 10:51:44 PM

Any chance of being able to override the location's default week start day, and have allowance for specifying the start of week day for a view, please?

Slava Shinderov  Staff  2/22/2024 5:19:54 AM

@basenine The system determines the first day of the week based on the database location settings.
Unfortunately, it's not possible to override this behavior for a specific view only.
As a workaround, you might consider creating a formula column using the `PrevDayOfWeek` function, which can be found here:
https://www.teamdesk.net/help/working-with-formulas/formula-building-blocks/functions/date-functions/prevdayofweek/
and then grouping your records using that column.