---
title: "Use the DATE Function to Create Dates from Specified Values"
slug: "date-function"
description: "Learn to use the DATE function to create a date from specified year, month, and day values. "
updated: 2025-11-27T14:27:00Z
published: 2025-11-27T14:27:00Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# DATE function

## Description

Creates a Date from the given year, month a day.

## Syntax

`DATE(Year, Month, Day)`

## Arguments

| Argument | Type | Dimensions | Description |
| --- | --- | --- | --- |
| *Year* (required) | Integer | Any Dimensions | Year of the date. |
| *Month* (required) | Integer | No Dimension or Dimensions of argument *Year* | Month of the date. |
| *Day* (required) | Integer | No Dimension or Dimensions of argument *Year* | Day of the date. |

## Returns

| Type | Dimensions |
| --- | --- |
| Text | Dimensions of argument *Year* |

## Examples

| Formula | Result | Description |
| --- | --- | --- |
| `DATE(2020, 12, 02)` | 02/12/2020 00:00:00 +00:00 | It returns a date in UTC time format with [Text](/v1/docs/data-types-in-pigment) data type. Use with [Locale date time](/v1/docs/format-using-locale-date-time) formatting to manage how it is displayed. |

> [!NOTE]
> ℹ️ **Note**
> 
> To convert a date to text format, use the DATE() function together with the [YEAR()](/v1/docs/year-function), [MONTH()](/v1/docs/month-function) and [DAY()](/v1/docs/day-function) functions. Select [Locale date time](/v1/docs/format-using-locale-date-time) formatting to manage how the date is displayed.
> 
> For example: `DATE(YEAR(your_date), MONTH(your_date), DAY(your_date))`
> 
> Where `your_date` refers to an object of Date data type in a List or Metric.

## See also

Excel: [DATE](https://support.microsoft.com/en-us/office/date-function-e36c0c8c-4104-49da-ab83-82328b832349)

> [!TIP]
> More of a hands-on learner?
> 
> Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!