Search…
Resources
Related 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, e.g. "2021 Q2".
yearquarter(Appointment)
Result: 2020 Q2 (with “Appointment”: 06/01/2021 09:00 – 06/16/2022 09:00 (US) and 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) and 01/06/2021 09:00 – 15/06/2022 09:00 (UK))
​
yearquarter(myDate) To return the quarter of a year of a given date, e.g. "2021 Q2".
​
yearquarter(datetime) To return the quarter of a year of a given timestamp, e.g. "2021 Q2".

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
Export as PDF
Copy link