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


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.


When the amount argument is a decimal value, the function rounds the input to the nearest integer.


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.