Week Number in Year

[SApple]

I'm needing to write a formula that will take a given date of a data record and return what week number in the year it falls in. For example: 12/31/01 would be week #53.

Thanks for your help.

 

[rhinok]

Do you want the calendar week or a literal week?

Example:

01/06/2002 falls in the second Calendar week

01/06/2002 falls in the first literal week (defined as 7 days/week).

 

[SApple]

Thanks! I want the calendar week number...

 

[kenhamady]

Try this. It might not work in every year.

Truncate (({date.field}- Date( Year({date.field}), 1, 1))/7) + 1 Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/