--- 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. " tags: ["DATE", "functions ", "formula syntax", "Pigment Boards", "Pigment Blocks", "Modeling and Formulas"] updated: 2025-11-27T14:27:00Z published: 2025-11-27T14:27:00Z canonical: "kb.pigment.com/date-function" --- > ## 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!