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!
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!