setting first week off year 1

[cm1234]

Hello out there

Im running CR 9,0 and my problem is that when making a report with week parameter in it starts with week 2 (03-01-05 to 09-01-05/ monday to Sunday) but its actually week 1 according to our calendar.
How to solve this????
Hope some one out here can help

Bet Regards
cm1234

 

[Madawc]

On Crystal 8.5, Datepart has the format DatePart (intervalType, inputDateTime, firstDayOfWeek, firstWeekOfYear). Leave out the last two and you get the default values.

Madawc Williams (East Anglia, UK)

 

[lbass]

The specific formula you would use is:

datepart("ww",{table.date},crMonday,crFirstFullWeek)

-LB