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.

Example

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.
Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us