Grouping by Date Field Weekly Always starts on a Sunday, Can I change this

[Former Member]

Post Author: mikazza

CA Forum: General

Hi,

I have a report which groups sales by the date they were made dailly, it also has another group which sits above this and groups these same sales by week so I can get a weekly sales figure aswell. All this works ok but the weekly bit always starts on a Sunday, is there any way to change this to start on a Monday instead?

Many thanks in advance

Michael

[Former Member]

Post Author: SKodidine

CA Forum: General

[Former Member]

Post Author: mikazza

CA Forum: General

It's okay,

Found the answer....

I created a group on a formula: datepart("ww",{TRANSACTION.TRANSACTION_DATE},crMonday)

and when creating this group I clicked customise group name field and entered this formula:

totext({TRANSACTION.TRANSACTION_DATE}-dayofweek({TRANSACTION.TRANSACTION_DATE},crMonday)+1, "dd/MM/yyyy")

This basically sets the start date of the week to Monday, change crMonday to whatever day you want to start from then.