0
week
In this article
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
Result: 52 (on New Year’s Eve 2021)
See also
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.
yearquarter
which returns the quarter and the year of a given date value.
Reply
In this article
Related articles
Content aside
- 4 mths agoMon, November 25, 2024 at 4:17 PM UTCLast active
- 64Views
-
1
Following