Formula to identify weeks in a month

[crzycrystlgrl]

Hi all
I am using CR9

I am trying to figure out a formula for crystal to recongnize days in "Week 1" , "Week 2" , "Week 3" etc for any given month.
So far the only thing I have come up with is hard coding every month with a if day is inbetween 1 and 7 then week 1.
Does anyone have a more dynamic soloution?
thanks in advance
Cynthia

 

[lbass]

Try:

Datepart("ww",{Orders.Order Date})+1
- Datepart("ww",({Orders.Order Date} - Day({Orders.Order Date})+1))

-LB

 

[crzycrystlgrl]

Thanks!! Works great!