To return the year of a given date value
This function provides the year from a date value as a number. You can use this function when calculating year numbers as well as filtering, sorting, and grouping records by year.
If you use the function for an appointment field, Ninox returns the start date of this appointment. If you need the end of an appointment, specify with
year(myDate)To return the year of a given date.
- 12/31/2021 (US)
- 31/12/2021 (UK))
year(myAppointment)To return the year of a given appointment.
- 06/01/2021 09:00 – 06/16/2022 09:00 (US)
- 01/06/2021 09:00 – 15/06/2022 09:00 (UK))
year(datetime)To return the year of a given timestamp.