Keypup

<b>Syntax</b>: <code>DAY([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 day in seconds (<code>86400</code>). With a datetime argument, it returns the day of the month portion (between 1 and 31) for the provided datetime.

<code>DAY()</code> is equal to <code>86400</code>

<code>DAY(created_at)</code> returns the day of the month (between 1 and 31) for the <code>created_at</code> field value

<code>AVG(closed_at-created_at)/DAY()</code> returns the time elapsed in days 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 + 10*DAY()</code> returns the <code>created_at</code> field valueplus 10 days.

- <code>DAY()</code> is equal to <code>86400</code>
- <code>DAY(created_at)</code> returns the day of the month (between 1 and 31) for the <code>created_at</code> field value
- <code>DAY(DATE(2023, 08, 27))</code> =&gt; <code>27</code>
- <code>AVG(closed_at-created_at)/DAY()</code> returns the time elapsed in days 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 + 10*DAY()</code> returns the <code>created_at</code> field valueplus 10 days.

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