DateAdd
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.