QUARTER

Calculates and Returns the Annual Quarter of a given date. This is compatible with the ODBC 3.0 AND ANSI SQL 92 Standards.

Quarters are split as:

1. 1st Jan – 31st Mar

2. 1st Apr – 30th Jun

3. 1st Jul – 30th Sep

4. 1st Oct – 31st Dec

QUARTER( <date_field or date> )

• date_field or date: The date to use in the calculation.

Example: Create a field to return the Annual Quarter a transaction was made on.

QUARTER( [TRANSACTIONS.PURCHASE DATE] )

Results:

• Returns a value of 1 for a purchase date of January 1st
• Returns a value of 2 for a purchase date of June 9th