> For the complete documentation index, see [llms.txt](https://v5docs.keyfax.biz/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://v5docs.keyfax.biz/reference/expression-reference/date-expressions/dateadd.md).

# DateAdd

Adds an interval to a date. A negative amount subtracts.

**Intervals**

| Code   | Meaning  |
| ------ | -------- |
| `s`    | Seconds  |
| `n`    | Minutes  |
| `h`    | Hours    |
| `d`    | Days     |
| `m`    | Months   |
| `q`    | Quarters |
| `ww`   | Weeks    |
| `yyyy` | Years    |

| Expression                                    | Databox value        | Result                |
| --------------------------------------------- | -------------------- | --------------------- |
| `DateAdd(12,"m")`                             | `15-10-2023 08:00pm` | `15/10/2024 20:00:00` |
| `DateAdd(10,'d') AsDate Format('dd/MM/yyyy')` | `01/08/2023`         | `11/08/2023`          |

Note that minutes are `n`, not `m` — `m` is months.

`DateAdd(Today, -1, 'yyyy')` gives this date last year, which is the usual way to build the far end of a window for [After](/reference/expression-reference/date-expressions/after.md) or [BetweenDates](/reference/expression-reference/date-expressions/betweendates.md).