Why is it that my calender says this week is nr 16 and this code:
SELECT ClientHost, SUM(AantalHits) AS Expr1, DATEPART(week, Datum) AS Maand
GROUP BY ClientHost, DATEPART(week, Datum)
says it's weeknr 17
Is it because this year starts with week 53 the first 2 days (1 and 2 Jan) ?
bytheway My system country is Dutch. (The Netherlands)