Keypup

<b>Syntax</b>: <code>WEEK([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 duration of a week in seconds (<code>604800</code>). With a datetime argument, it returns the week of the year (between 1 and 52) for the provided datetime

<code>WEEK()</code> is equal to <code>604800</code>

<code>WEEK(created_at)</code> returns the week of the year for the <code>created_at</code> field value

<code>WEEK(DATE(2023, 08, 27))</code> returns <code>34</code>.

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

- <code>WEEK()</code> is equal to <code>604800</code>
- <code>WEEK(created_at)</code> returns the week of the year for the <code>created_at</code> field value
- <code>WEEK(DATE(2023, 08, 27))</code> returns <code>34</code>.
- <code>AVG(closed_at-created_at)/WEEK()</code> returns the time elapsed in weeks 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*WEEK()</code> returns the <code>created_at</code> field value plus 2 weeks (14 days).

WEEK

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