Adds the specified value for the specified date or time part to a date, time, or timestamp. This function is redundant with the Add_Days() etc. functions which were added to be a bit more simple and clear. Both functions are adequate. Date Part examples: Year, Month, Week, Day, Hour, Minute, Second.

​Syntax

DATEADD(Date or Time Part,Value,Date/Time)

​
​Arguments

Date or Time Part:

This indicates the units of time that you want to add. For example, if you wanted to add 2 days this would be DAY.

Value:

This is the number of units of time that you want to add. For example, if you wanted to add 2 days, this would 2.

Date/Time:

This is the data, time, or timestamp to which you want to add. For example, if you wanted to add 2 days to August 1, 2018 this would be "2018-08-01".

​
​Example

"LoadSheet"."Date" = 3/21/2019
​
DATEADD(DAY,2,"LoadSheet"."Date") = 3/23/2019