Create a Date Grouping

[checkai]

I want to group dates by Week, However when I choose this in the Group Expert it starts on a Sunday. Any Idea on how to group it starting with Monday through Sunday?

Thanks,
DLC

 

[Madawc]

Crystal regards Sunday as Day Number 1, I assume that's what you're getting. You could write your own Formula Field to add 7 if Day Number = 1 or otherwise use the Day Number. Madawc Williams
East Anglia
Great Britain

 

[lyanch]

I have this problem too as my "week" runs thursday- wednesday.

Solution:

Create a formula that "adds" days to your date field so that yourfirstdayofweek data turns into Sunday. In my case I add 3 to turn thursday into monday.

Group on that field by week..

I create a group header outside of the "custom group header" because I get better results..

@groupheader

date(GroupName ({firstdayofweekformula}, "weekly&quot) -3

The -3 corresponding to the +3 in the firstdayofweekformula...

Lisa