Last updated: August 26, 2026.
The DateAdd function adds a specified number of time intervals to a date.
Syntax
DateAdd(interval, number, date)| Argument | Description |
|---|---|
interval | String such as yyyy, q, m, d, ww, h, n, or s |
number | Number of intervals to add |
use a negative value to subtract | undefined |
date | Starting date or time |
Examples
DateAdd("d", 30, Date()) ' 30 days from today
DateAdd("m", -1, [OrderDate]) ' One month earlier
DueAt: DateAdd("h", 48, [CreatedAt])DateAdd adjusts end-of-month results to a valid date. Use four-digit years and test month calculations around leap years and month boundaries.
See Microsoft’s Access function reference for related expression functions.
Moving an Access application to the web? See how PHPRunner can replace Access forms, queries, and reports.
