sql server get week number from date range code example Example: sql server week number datepart(wk, DateToParse)