Function Index


Adds the specified quantity of time to a date.



unit (required) Unit of the amount of time to add. You can choose to add either “year”, “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.

More About

Date Functions

Date functions are useful for analyzing date input and extracting individual time components, like year or minute, from date objects.