Page History

WEEKNUMBER

This function returns the week number within the year of a given date or dateTime value. The week number is returned as an integer in the range 1 - 53. Week 1 for a year is the earliest seven day period starting at Monday that contains at least 4 days from that year. This definition reflects the ISO 8601 Week dates definition.

For example, January 1, 2015 was a Thursday. Therefore week 1 of 2015 starts on December 29, 2014, and ends on January 4, 2015.

Syntax

WEEKNUMBER ( date | dateTime )

Inputs

• date or dateTime - The date or dateTime value of which the week number must be returned.

Return type

• integer

Examples