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.


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.


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