Change start day of the week for a group

[bartsimpson]

How do I change the start day of the week ?

I'm grouping on a date field, and Crystal groups from Sunday to Saturday by default. I need to change the grouping to Monday to Sunday.

Help !

 

[Madawc]

In Crystal 8.5, you can get the Monday of last week as
currentdate-5 - dayofweek(currentdate)
and its Sunday as
currentdate+1 - dayofweek(currentdate)

Do a formula field which tests such dates, and group as last week, week before etc.

Madawc Williams
East Anglia, Great Britain

 

[bartsimpson]

Thanks Madawc.

I've also found a way forward on the Crystal web site :

http://support.businessobjects.com/library/kbase/articles/c2008585.asp