---
title: DATE
description: Learn how to use the DATE function to create dates from specified year, month, and day components for calculated columns.
---

import { Steps } from '@astrojs/starlight/components';

# DATE

The DATE function in Infoveave creates a date based on the specified year, month, and day components.

## Applicable to

Calculated Columns

## Return Value

The function returns a date value in the format YYYY-MM-DD based on the specified year, month, and day.

## Remark

* The DATE function does not perform any validation on the input values.
* The YEAR is recommended to have an argument of four digits.
* The MONTH and DAY are recommended to have arguments of two digits.
* Decimal values will be rounded to the closest value.
* Valid values for MONTH are 01-12. If MONTH is a number from 01 to 12, then it represents a month of the year. If you enter an integer larger than 12, the date is calculated by adding the value of month to the year.
* Valid values for DAY are 01-31. If DAY is a number from 01 to 31, then it represents the day of the year. If you enter an integer larger than 31, the date is calculated by adding the value of day to the month and year.

## Syntax

```
DATE(year, month, date)
```

## DATE in Calculated Columns

| Expression | Description |
|---|---|
| Year | The substring you want to substitute. |
| Month | The substring that will substitute your search. |
| Day | The occurrence of substring you want to substitute. |

Steps to Use DATE

<Steps>
1. Write the DATE function. For instance ```DATE(year, month, date)```
2. Replace `year` with the year value required.
3. Replace `month` with the month value required.
4. Replace `day` with the day value required.
5. To learn how to add calculated columns in Infoveave, visit the section [Calculated Columns](/studio-v8/datasources/calculated-columns-datasource/).
</Steps>

**Example**

Suppose you want to create a date for January 21, 2024. You can use the DATE function as follows

```
DATE(2024, 01, 21)
```