Keypup

Function: <code>YEAR_MONTH_DAY</code>

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

Description: Format a datetime in <code>YYYY-MM-DD</code> format (e.g. “2023-11-07”). This formatter is used to group records in “year + month + day” blocks, ignoring hours, minutes, and seconds.

<code>YEAR_MONTH_DAY("2020-04-17")</code> returns <code>2020-04-17</code>.

<code>YEAR_MONTH(created_at)</code> returns the <code>created_at</code> field value in <code>YYYY-MM-DD</code> format.

- <code>YEAR_MONTH_DAY("2020-04-17")</code> returns <code>2020-04-17</code>.
- <code>YEAR_MONTH(created_at)</code> returns the <code>created_at</code> field value in <code>YYYY-MM-DD</code> format.

YEAR_MONTH_DAY

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