HowTo: Formula for calculating the quarter of a year from a date field

Seatable has a nice grouping feature. You can group a date field by quarter. Especially for tax reasons this is a nice feature. But there are limitation in grouping and you cannot use quarter to filter records.

One way around is a new formula field in which you can calculate the quarter. With this field you can combine grouping an use it for filtering. For example first group by year and on level 2 group by the quarter of the year:

grafik

The formular for this field is:

if({RE-Datum}, year({RE-Datum}) & "-Q" & int(((month({RE-Datum}) - 1) / 3) + 1), "")

grafik

If you need only the quarter (without the year) just remove the first part year({RE-Datum}) & "-Q" &

BTW: The if-statement is only necessary to avoid errors or warnings when the field “RE-Datum” is empty.

TOMO

3 Likes

Thanks for sharing this with the SeaTable community.

1 Like