Keypup

<b>Syntax</b>: <code>QUARTER([datetime])</code>

<b>Description</b>: This function has two different modes of operation, based on whether an argument is provided or not. With no arguments, it returns the standard duration of a quarter in seconds (<code>7776000</code>, which is based on 90 days). With a datetime argument, it returns the quarter portion (between 1 and 4) for the provided datetime

<code>QUARTER()</code> is equal to <code>7776000</code>

<code>QUARTER(created_at)</code> returns the quarter of the year for the <code>created_at</code> field value

<code>QUARTER(DATE(2023, 08, 27))</code> =&gt; <code>3</code>

<code>AVG(closed_at-created_at)/QUARTER()</code> returns the time elapsed in quarters between the creation and closing of a record. Note that the difference between two dates (<code>closed_at-created_at</code>) is always returned in seconds.

<code>created_at + 2*QUARTER()</code> returns the <code>created_at</code> field value plus 2 quarters.

- <code>QUARTER()</code> is equal to <code>7776000</code>
- <code>QUARTER(created_at)</code> returns the quarter of the year for the <code>created_at</code> field value
- <code>QUARTER(DATE(2023, 08, 27))</code> =&gt; <code>3</code>
- <code>AVG(closed_at-created_at)/QUARTER()</code> returns the time elapsed in quarters between the creation and closing of a record. Note that the difference between two dates (<code>closed_at-created_at</code>) is always returned in seconds.
- <code>created_at + 2*QUARTER()</code> returns the <code>created_at</code> field value plus 2 quarters.

QUARTER

Find answers and get help from Intercom Support and Community Experts

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Title

Track the progress of all tickets related to your company.

Tickets portal.

{assigneeName} needs more information from you