How to group by week number

[sk8er1]

I need to create a report that groups on week number.
How can i do that in crystal.

Thanks

 

[sk8er1]

My original report (in access) is calculating the week number this way...how can it be done in crystal?


WeekNo: DatePart("ww",[Schedule Date])+1-DatePart("ww",[Schedule Date]-Day([Schedule Date])+1)

 

[cmv131]

Create a formula

datepart("ww", DateField)

and group on that

 

[cmv131]

Just tested the code below and it worked fine. Make sure in Crystal to use { } instead of [ ] as well

DatePart("ww",{Schedule Date})+1-DatePart("ww",{Schedule Date}-Day({Schedule Date})+1)