Function Index

DateAdd

Adds the specified quantity of time to a date.

Usage

DateAdd(<unit>,<amount>,<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.

Examples

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.