>It seems that you cannot use the quarter function within a select statement.
>
Sure you can

CREATE CURSOR test (ii i AUTOINC, date D)
INSERT INTO test (date) VALUES (DATE())
INSERT INTO test (date) VALUES (DATE()-120)
INSERT INTO test (date) VALUES (DATE()+120)
SELECT *, QUARTER(date) FROM test