Make Monday the First Day of Week 1

[tester3223]

I created a report which groups sales of my company's product first by the week, then by days.

e.g.
Week beginning: Sunday March,7th,2004
Sunday 7th Sales,
Monday 8th Sales,
Tuesday 9th Sales etc.


Instead of Sunday being the start day of the week, however, I would like to set the start day to Monday.

i.e.
Week beginning: Monday March,8th,2004
Monday 8th Sales,
Tuesday 9th Sales,
Wednesday 10th Sales,
Thursday 11th Sales,
Friday 12th Sales,
Saturday 13th Sales,
Sunday 14th Sales

Thanks in advance for your help!!!

 

[IdoMillet]

Use the firstDayOfWeek argument in the DatePart function and an interval type of "ww".

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[tester3223]

Thanks ido! That worked fine!