Search…
Resources
Related Links
week
To return the calendar week of a given date value
This function tells you the week of a given date value as a number with 1st week = 1, 2nd week = 2, … 53rd week = 53. You can use all data types.
When using the data type “appointment” the function will return the calendar week of the start date.

Syntax

week(date)
week(timestamp)
week(appointment)

Return

number

Examples

week(today())
Result: 52 (on New Year’s Eve 2021)

See also

​day, which converts to or returns a date value.
​month, which returns the month from a date value as a number.
​quarter, which returns the quarter of a given date value as a number.
​year, which returns the year of a given date value.
Last modified 2mo ago
Export as PDF
Copy link