Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to find number of weeks in a date range

Status
Not open for further replies.

retygh45

IS-IT--Management
May 23, 2006
166
US
I'm sure this is probably easy, but I can't figure it out. I have a date range that the user enters, so it really could be any range, but I'm trying to find the number of weeks in that range.

I'm trying to figure out a "weekly" average of the number of claims for each person, so I have the total number of claims, and a date range, but I need to divide by the number of weeks.

I was trying to use the datepart 'ww', but I don't know if that's correct.

Any help is appreciated, thanks!
 
datediff("ww", minimum({?daterange}),maximum({?daterange}))

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top