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. Jan-1 to Mar-31

  2. Apr-1 to Jun-30

  3. Jul-1 to Sep-30

  4. Oct-1 to Dec-31

QUARTER( <date_field or date> )

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

Note: dates in Audiences need to be formatted as either YYYY-MM-DD or MM/DD/YYYY. Entering a date as 01-02-2023 would be read as Jan-2 not 1-Feb.

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.