Keypup

Function: <code>BEGINNING_OF_MONTH</code>

Syntax: <code>BEGINNING_OF_MONTH(datetime)</code>

Description: Returns a datetime corresponding to the beginning of month for the provided datetime or <code>NOW</code> if no value is provided.

<code>BEGINNING_OF_MONTH(created_at)</code> returns the <code>created_at</code> field value set at midnight on the first day of the month. If <code>created_at</code> is equal to <code>2023-02-23T15:39:21Z</code> then

<code>BEGINNING_OF_MONTH(created_at)</code> returns <code>2023-02-01T00:00:00Z</code>.

<code>BEGINNING_OF_MONTH()</code> is equal to <code>BEGINNING_OF_MONTH(NOW())</code>

<code>BEGINNING_OF_MONTH(DATE(2023, 2, 15))</code> is equal to <code>DATE(2023, 2, 1)</code>

- <code>BEGINNING_OF_MONTH(created_at)</code> returns the <code>created_at</code> field value set at midnight on the first day of the month. If <code>created_at</code> is equal to <code>2023-02-23T15:39:21Z</code> then 
 <code>BEGINNING_OF_MONTH(created_at)</code> returns <code>2023-02-01T00:00:00Z</code>.
- <code>BEGINNING_OF_MONTH()</code> is equal to <code>BEGINNING_OF_MONTH(NOW())</code>
- <code>BEGINNING_OF_MONTH(DATE(2023, 2, 15))</code> is equal to <code>DATE(2023, 2, 1)</code>

BEGINNING_OF_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