how to group data into weeks

[vatawna]

I'd like to group data into week1, week2, week3, and week4 for each month. For example, if the report was processed on 2/5/07, the data should be in week1. If it was processed on 2/12/07, it should be in week2.

Does anyone know what formula or function would help me do this?

Thanks.

 

[FrankTWall]

Select the date you require the group on, create group and then you get an option in the group dialogue box to group by day, week, month etc.

 

[lbass]

Create a formula {@weekno} like this:

datepart("ww",{table.date})-
datepart("ww",{table.date}-day({table.date})+1) + 1

Then insert a group on this formula.

-LB