How to group by week starting on Monday

[javedi]

Hi Guys,

How can items be grouped by week to start from a Monday and not a Sunday as it is in Crystal Reports 10?

Any tips would be appreciated.

Thanks,
Javedi

 

[goranm]

Hi!

Create a formula like:
DatePart ("ww",sysdate, crMonday)

And then group on that formula.

/Goran

 

[javedi]

Hi Goran,

The Crystal compiler does not like sysdate. should i be replacing this with something?

Thanks,
Javed

 

[bdreed35]

You need to replace sysdate with your database date field.
The formula posted will return a number for you to group on.
If you want a date, then you can use this:

if dayofweek({table.date}) = 1
then {table.date} - 6
else {table.date} - dayofweek({table.date}) + 2

~Brian

 

[javedi]

Hi Brian,

Thanks for clearing this up. I did try the date field but it displayed numbers which were no use.

I'll give your formula a go.

DO you know if there is a default setting somewhere in Crystal 10?

Many thanks,
Javed

 

[bdreed35]

Unfortunately there is not.

~Brian

 

[goranm]

Sorry, I missed that one.

As Brian said it shall look like:
DatePart ("ww",{table.date}, crMonday).

That will give you the week number with a week starting on monday.

Wasn´t that what you wanted?

/Goran