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.
week(date)
week(timestamp)
week(appointment)
number
Result: 52 (on New Year’s Eve 2021)
date, which converts to or returns a date value.
day, which returns the day of the month from a given date value as a number.
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.