quarter

quarter(d: date) 🡒 number, pure const function

Returns the quarter of a date. That is, it will return:

Example:

table T = with
  [| as D |]
  [| date(2024,  1,  3) |]
  [| date(2024,  3, 16) |]
  [| date(2023, 11,  2) |]
  [| date(2022,  7, 31) |]

show table "" a1b4 with
  T.D as "Date"
  quarter(T.D) as "Quarter"

Will display the table:

Date Quarter
2024-01-03 1
2024-03-16 1
2023-11-02 4
2022-07-31 3
User Contributed Notes
0 notes + add a note