Week(date)

Returns the ordinal for the week number in a year; an integer ranging from 1 to 53.

See also DatePart.

date

Any date/time value or string convertible to date.

Usage

Years less than 100 are interpreted as 20th century values.

When passing date as a string, make sure it is enclosed in quotes. Otherwise, it is interpreted as a number representation of a date returning undesired results.