Keypup

<b>Syntax</b>: <code>MONTH([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 month in seconds (<code>2629746</code>, which is based on 30 days). With a datetime argument, it returns the month portion (between 1 and 12) for the provided datetime

<code>MONTH()</code> is equal to <code>2629746</code>

<code>MONTH(created_at)</code> returns the month of the year for the <code>created_at</code> field value

<code>MONTH(DATE(2023, 08, 27))</code> =&gt; <code>8</code>

<code>AVG(closed_at-created_at)/MONTH()</code>returns the time elapsed in months 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*MONTH()</code> returns the <code>created_at</code> field valueplus 2 months.

- <code>MONTH()</code> is equal to <code>2629746</code>
- <code>MONTH(created_at)</code> returns the month of the year for the <code>created_at</code> field value
- <code>MONTH(DATE(2023, 08, 27))</code> =&gt; <code>8</code>
- <code>AVG(closed_at-created_at)/MONTH()</code>returns the time elapsed in months 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*MONTH()</code> returns the <code>created_at</code> field valueplus 2 months.

MONTH

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