Adds the specified quantity of time to a date.


DateAdd(unit, amount, date)

unit (required) Unit of the amount of time to add. You can choose to add either “year”, "quarter", “month”, “week”, “day”, “hour”, “minute”, or “second”.

amount (required) The quantity of time to add.

date (required) The date or column of dates you are adding to.

NOTE: The quantity to add is rounded to the nearest whole number.


DateAdd("minute", 60, Date("1999-12-31 23:00:00"))
  • Returns “2000-01-01 00:00:00” adding 60 minutes to the date.
DateAdd(“day”, 7, [Date])
  • Adds 7 days to every date in a column of dates.