WEEKOFYEAR
Syntax
WEEKOFYEAR(<date>)
Description
Returns the week of the year for the supplied date in a range from 1 to 53.
Examples
Date | WEEKOFYEAR Returns |
---|---|
Jan 1, 2018 12:23:05 | 1 |
Jun 14, 2018 12:23:05 | 24 |
Dec 25, 2018 12:23:05 | 52 |
WEEKOFYEAR(<date>)
Returns the week of the year for the supplied date in a range from 1 to 53.
Date | WEEKOFYEAR Returns |
---|---|
Jan 1, 2018 12:23:05 | 1 |
Jun 14, 2018 12:23:05 | 24 |
Dec 25, 2018 12:23:05 | 52 |