I want to work out weekly stats on specific records for the year, what i want to achieve is the following: -
I want to count a new week starting on a monday and ending on sunday
For each year start week 1 on the first monday of january
How do i go about setting this up ?
I have the following query but this counts from Sunday first
WHERE DATEPART(week, GETDATE()) = DATEPART(week, dateadded)
So the output would be for today 12/04/05: -
Record count 3 etc..