Adds the specified quantity of time to a date.

See Sigma's Common Date Functions and Use Cases lab for more information about date functions, including use cases and exercises.

Usage

DateAdd(unit, amount, date)

unit (required) Unit of the amount of time to add; this can be specified with “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.

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 page helpful?
Yes No