Search…
⌃K
Links

yearquarter

To return the quarter and the year of a given date value
You will get the year and quarter from a given date value displayed in the format “YYYY Q1”.
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

yearquarter(appointment)
yearquarter(date)
yearquarter(datetime)
yearquarter(timestamp)

Return

string

Examples

yearquarter(myAppointment) To return the quarter of the year of a given appointment.
yearquarter(Appointment)
Result: 2020 Q2
(with Appointment =
  • 06/01/2021 09:00 – 06/16/2022 09:00 (US)
  • 01/06/2021 09:00 – 15/06/2022 09:00 (UK))
yearquarter(endof(Appointment))
Result: 2022 Q2
(with Appointment =
  • 06/01/2021 09:00 – 06/16/2022 09:00 (US)
  • 01/06/2021 09:00 – 15/06/2022 09:00 (UK))
yearquarter(myDate) To return the quarter of a year of a given date.
yearquarter(datetime) To return the quarter of a year of a given timestamp.

See also

yearweek, which returns the week and the year of a given date value.
yearmonth, which returns the month and the year of a given date value.
Last modified 2mo ago