Calculate what week of the year it is

[nickloe]

In one of my reports I need to base a calculation on what week it is of the year. For example, Feb 9 - 13 is the 6th full week of the year.

Does anyone know how to get this calculation?

Thanks!! Nick

 

[IanWaterman]

Use Crystal function datepart

datepart("ww", {datefield})

This will return week number of year.

Ian

 

[lbass]

I think you would have to add the FirstDayofWeek and FirstWeekofYear arguments:

datepart("ww",currentdate,crSunday,crFirstFullWeek)

Note that to use FirstWeekofYear argument correctly, you have to also specify the FirstDayofWeek.

-LB