yearweek
To return the week and the year of a given date value
You will get the year and the week from a given date value, displayed in the format “YYYY WW”. This can help you filter, sort, and group records.
If you use the function for an appointment field, Ninox returns the start date of this appointment. If you need the end date of an appointment, specify with endof().
Syntax
yearweek(appointment)
yearweek(date)
yearweek(timestamp)
Return
string
Examples
yearweek(myAppointment) To return the week of a year of a given appointment.
yearweek(Appointment)Result: 2021 23
(with Appointment =
06/01/2021 09:00 – 06/16/2022 09:00 (US)
01/06/2021 09:00 – 15/06/2022 09:00 (UK))
yearweek(endof(Appointment))Result: 2022 24
(with Appointment =
06/01/2021 09:00 – 06/16/2022 09:00 (US)
01/06/2021 09:00 – 15/06/2022 09:00 (UK))
yearweek(myDate) To return the week of a year of a given date.
yearweek(datetime) To return the week of a year of a given timestamp.
See also
yearquarter, which returns the quarter and the year of a given date value.
yearmonth, which returns the month and the year of a given date value.