fbpx
Select Page

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.

More About Date Functions

Date functions are useful for analyzing date input and extracting individual time components, like year or minute, from date objects.

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.