> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# DateAdd

> Use the Sigma DateAdd function to add or subtracts a specified amount of time from a date.

The **DateAdd** function adds or subtracts a specified amount of time from a date. You can specify the unit of time used to modify the date, such as years, months, or days.

You can use the **DateAdd** function to:

* Add or subtract time from a specific date
* Adjust the time for every date in a column with the [date data type](/docs/data-types-and-formats#date).
* Determine what date it was a specified number of days ago, or in the future

## Syntax

```
DateAdd(unit, amount, date)
```

Function arguments:

|            |                                                                                                                       |
| :--------- | :-------------------------------------------------------------------------------------------------------------------- |
| **unit**   | (required) The unit of time to add (one of "year", "quarter", "month", "week", "day", "hour", "minute", or "second"). |
| **amount** | (required) The number of units to add.                                                                                |
| **date**   | (required) The date value or column of date values to which the function adds time.                                   |

## Usage notes

* The **unit** argument does not support columns.
* If the **date** or **amount** arguments are `Null`, the function returns `Null`.
* If the **amount** argument is a number with a decimal, the function truncates it to its integer value, removing the decimal value.
  * For example, `DateAdd("day", 1.9, Date("2020-01-01 12:00:00"))` truncates the **amount** argument to `1` and adds one day to the specified date, returning `2020-01-02 12:00:00`.
* If the **unit** argument is "month" and the **date** argument is a day that doesn't exist in the resulting month, the function returns the last day of that month.
  * For example, `DateAdd("month", 1, Date("2020-01-31"))` adds one month to the specified date and returns `2020-02-29`, the last day of February 2020.

## Examples

```
DateAdd("minute", 60, Date("1999-12-31 23:00:00"))
```

Adds 60 minutes to the specified date and returns `2000-01-01 00:00:00`.

```
DateAdd("day", 1.9, Date("2020-01-01 12:00:00"))
```

Truncates the decimal portion of the **amount** argument to its integer value and adds one day to the specified date, returning `2020-01-02 12:00:00`.

```
DateAdd("month", 1, Date("2020-01-31"))
```

Adds one month to the specified date and returns `2020-02-29`.

```
DateAdd(“day”, 7, [Date])
```

Adds seven days to every date in the *Date* column.

```
DateAdd(“year”, -1, [Date])
```

Subtracts one year from every date in the *Date* column.

## Related resources

* <a href="https://quickstarts.sigmacomputing.com/guide/common_date_functions/index.html" target="_blank" rel="noopener noreferrer">
    Sigma Quickstart: Common date functions and use cases
  </a>