Week number 3

[acessn]

Using Crystal Reports 9.0, Microsoft SQL server db

I have a date, and need to determine the week number of that date.

I.E. 21.03.2005 needs to return week number 12.

Any ideas?

Regards Bjørn

 

[jambu]

try this ...

DateDiff ("ww", date(year(today),1,1), today);

It's the number of 'start of weeks' after the first date and including the second date. There is a "w" argument as well that is slightly different.

There is further information in the help file.

 

[lbass]

Try:

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

You can change the way you count week 1 of the year by adding conditions to this formula for the first day of the week and the first week of the year, as in:

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

The help files will give you the other options you can use for these conditions.

-LB