DateAdd

Description

Adds a specified unit of time to a date value

Syntax

DATEADD(<datepart>, <number>, <date>)

Arguments

Argument Type Description Optional
datepart DateInterval (see definition below) Units of measurement to use for the addition No
number Decimal/Integer Number of units to be added to date parameter No
date DateTime DateTime value to which units are added No

DateInterval

Value Description
yy or yyyy Year
mm or m Month
d or dd Day
hh or h Hour
mi or n Minute
ss or s Second

Returns

DateTime Value

Examples

Expression: DATEADD("yy", 1, "2014-01-01")
Returns: 2015-01-01
Expression: DATEADD("mi", 1, "2013-1-1 10:10")
Returns: 2013-1-1 10:11
Expression: DATEADD("dd", 1, "2013-1-1")
Returns: 2013-1-2

Download

Download Example