Keypup

<b>Syntax</b>: <code>YEAR([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 year in seconds (<code>2629746</code>, which is based on 365 days). With a datetime argument, it returns the year portion for the provided datetime

<code>YEAR()</code> is equal to <code>31556952</code>

<code>YEAR(created_at)</code> returns the year portion for the <code>created_at</code> field value

<code>YEAR(DATE(2023, 08, 27))</code> returns <code>2023</code>

<code>AVG(closed_at-created_at)/YEAR()</code> returns the time elapsed in years 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*YEAR()</code> returns the <code>created_at</code> field value plus 2 years.

- <code>YEAR()</code> is equal to <code>31556952</code>
- <code>YEAR(created_at)</code> returns the year portion for the <code>created_at</code> field value
- <code>YEAR(DATE(2023, 08, 27))</code> returns <code>2023</code>
- <code>AVG(closed_at-created_at)/YEAR()</code> returns the time elapsed in years 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*YEAR()</code> returns the <code>created_at</code> field value plus 2 years.

YEAR

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