# DateAdd

The **DateAdd** function adds a specified amount of time to a date.

### Syntax

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

Function arguments:

|            |                                                                                                      |
| ---------- | ---------------------------------------------------------------------------------------------------- |
| **unit**   | (required) The unit of time to add (i.e., 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.                  |

### 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”, 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.