Week No - Formula

[Shin25]

Hi All

I am using CRXI Rel 2...to develop a report...I have a dt field and I want to break this week into weeknumber of the year eg. 1 - 52/53

The report will be restricted (select expert) by the YTD formula.

I hope I have not missed any information...

Please can you help...

tc

 

[lbass]

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

-LB

 

[Shin25]

thanks for that ibass, I have a group by month which I want the user to click and then the week number to show....how would I do that?

Many Thanks

 

[Shin25]

been long time since I used Crystal....to this degree...I figured it out...

Cheers